Data Type MSSQL

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