Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. 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)