YEAR: return the year portion of a date : Year « Date Timezone « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Date Timezone
  3. Year

YEAR: return the year portion of a date


1> ---------------------------------------------------
2> -- YEAR: return the year portion of a date.
3>
4> SELECT YEAR("24 March 1964")
5> GO

-----------
       1964

(1 rows affected)
1>








Related examples in the same category

1.The DAY(), MONTH(), and YEAR() Functions
2.Using Functions in Queries
3.select YEAR('2002-09-30')