Displaying the Integer Value For Part of a Date using YEAR : Year « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. Year
35>
36> SELECT YEAR(GETDATE())
37> GO

-----------
       2007

(1 rows affected)








10.14.Year
10.14.1.Displaying the Integer Value For Part of a Date using YEAR
10.14.2.select YEAR('2002-09-30')