Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. Select DATENAME(year, 2002-09-30 11
3> select DATENAME(year, '2002-09-30 11:35:00')
4> GO
------------------------------
2002
(1 rows affected)