Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

SELECT CONVERT(datetime, 10 12 99,4)

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