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

Displaying the Integer Value For Part of a Date using YEAR

   <source lang="sql">

35> 36> SELECT YEAR(GETDATE()) 37> GO

---

      2007

(1 rows affected)</source>

select YEAR("2002-09-30")

   <source lang="sql">

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

---

      2002

(1 rows affected)</source>