Date Functions MSSQL Tutorial

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