Data Convert Functions MSSQL Tutorial

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