Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

SELECT CONVERT(datetime, 10 12 99,1)

4>  SELECT CONVERT(datetime, '10.12.99',1) 5> GO ----------------------- 1999-10-12 00:00:00.000 (1 rows affected)