hijri Date ! shortdate

[tanatif]

i found this

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 ?

 

[tanatif]

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

 

[tanatif]

see result

in attachment

 

[SQL_Hell]

--code to get date only
select convert(date,getdate())
　
　
　
--added to your format statement
select format(convert(date, getdate()), 'dd/MM/yyyy', 'ar-SA' )

 

[tanatif]

THANK YOU SQL_Hell

 

[tanatif]

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

 

[SQL_Hell]

I can't really understand what you're talking about here