2>3> select CAST('2002-09-30 11:35:00' AS smalldatetime) - 14> GO-------------------- 2002-09-29 11:35:00(1 rows affected)