Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. Displaying the Integer Value For Part of a Date using YEAR
35>
36> SELECT YEAR(GETDATE())
37> GO
-----------
       2007
(1 rows affected)