select YEAR('2002-09-30') : Year « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. Year
4> select YEAR('2002-09-30')
5> GO

-----------
       2002

(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')