| title | YEAR (Transact-SQL) | ||||||
|---|---|---|---|---|---|---|---|
| description | YEAR (Transact-SQL) | ||||||
| author | MikeRayMSFT | ||||||
| ms.author | mikeray | ||||||
| ms.date | 03/14/2017 | ||||||
| ms.service | sql | ||||||
| ms.subservice | t-sql | ||||||
| ms.topic | reference | ||||||
| ms.custom |
|
||||||
| f1_keywords |
|
||||||
| helpviewer_keywords |
|
||||||
| dev_langs |
|
||||||
| monikerRange | >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb]
Returns an integer that represents the year of the specified date.
For an overview of all [!INCLUDEtsql] date and time data types and functions, see Date and Time Data Types and Functions (Transact-SQL).
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
YEAR ( date )
date
Is an expression that can be resolved to a time, date, smalldatetime, datetime, datetime2, or datetimeoffset value. The date argument can be an expression, column expression, user-defined variable or string literal.
int
YEAR returns the same value as DATEPART (year, date).
If date only contains a time part, the return value is 1900, the base year.
The following statement returns 2010. This is the number of the year.
SELECT YEAR('2010-04-30T01:01:01.1234567-07:00'); The following statement returns 1900, 1, 1. The argument for date is the number 0. [!INCLUDEssNoVersion] interprets 0 as January 1, 1900.
SELECT YEAR(0), MONTH(0), DAY(0); Examples: [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW]
The following statement returns 1900, 1, 1. The argument for date is the number 0. [!INCLUDEssNoVersion] interprets 0 as January 1, 1900.
SELECT TOP 1 YEAR(0), MONTH(0), DAY(0);