Mega Code Archive
Categories
/
MSSQL
/
Data Type
Select CAST(2002-09-30 11
2> 3> select CAST('2002-09-30 11:35:00' AS smalldatetime) - 1 4> GO -------------------- 2002-09-29 11:35:00 (1 rows affected)