Mega Code Archive

 

Categories / MSSQL / Data Type

 

CONVERT function syntax

5> 6> 7> SELECT CONVERT(datetime,(CONVERT(varchar,GETDATE(),112))) 8> GO ----------------------- 2008-08-17 00:00:00.000 (1 rows affected)