hijri Date ! shortdate

tanatif

Registered User.
Local time
Today, 01:01
Joined
Feb 10, 2016
Messages
40
i found this

Code:
In SQL Server 2012 you can use new function called format as the following

SELECT FORMAT ( GETDATE(), ‘dd/MM/yyyy’, ‘ar-SA’ )

Result

16/08/1435

but where i paste that in sql database table ?
 
i try but result is :

2016-02-12 00:00:00


i dot wont 00:00:00

only 2016-02-12 by this setting 1437/05/08
 
see result

in attachment
 

Attachments

  • date.png
    date.png
    1.8 KB · Views: 209
--code to get date only
select convert(date,getdate())
 
 
 
--added to your format statement
select format(convert(date, getdate()), 'dd/MM/yyyy', 'ar-SA' )





 
Last edited:
PLEASE I TRY BUT NOT GOOD RESULT

[Microsoft][ODBC SQL Server Driver]Datetime field overflow(#0)

some one HE IS TALKING ABOUT ERROR HANDLEING

instead of 2003, the same error will be produced. Just add some error handling to your Access form, and you'll be all set.

PLEASE HOW TO HELP ME
 
I can't really understand what you're talking about here
 

Users who are viewing this thread

Back
Top Bottom