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>