Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

SELECT CONVERT(datetime, CONVERT( varchar(11), 2005-08-13 20

3> 4> SELECT CONVERT(datetime, CONVERT( varchar(11), '2005-08-13 20:37:22.570', 101)) 5> GO ----------------------- 2005-08-13 00:00:00.000 (1 rows affected)