Data Types MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Data Types
  4. 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)