Mega Code Archive

 

Categories / MSSQL / Data Type

 

CAST(111172 as smalldatetime) AS 111172

1> SELECT 2>    CAST('11/11/72' as smalldatetime) AS '11/11/72', 3>    CAST('6/5/40' as smalldatetime) as '6/5/40' 4> GO 11/11/72             6/5/40 -------------------- --------------------  1972-11-11 00:00:00  2040-06-05 00:00:00 (1 rows affected) 1>