Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. Select YEAR(2002-09-30)
4>  select YEAR('2002-09-30')
5> GO
-----------
       2002
(1 rows affected)