SQL Server/T-SQL Tutorial/Date Functions/Year

Displaying the Integer Value For Part of a Date using YEAR

35>
36> SELECT YEAR(GETDATE())
37> GO
-----------
       2007
(1 rows affected)

select YEAR("2002-09-30")

4> select YEAR("2002-09-30")
5> GO
-----------
       2002
(1 rows affected)