Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

SELECT DATEADD(mi, -30, 2005-09-01 23

3> 4> SELECT DATEADD(mi, -30, '2005-09-01 23:30:00.000') 5> GO ----------------------- 2005-09-01 23:00:00.000 (1 rows affected)