| title | YEAR (Transact-SQL) | ||||||
|---|---|---|---|---|---|---|---|
| description | YEAR (Transact-SQL) | ||||||
| author | MikeRayMSFT | ||||||
| ms.author | mikeray | ||||||
| ms.reviewer | |||||||
| ms.date | 03/14/2017 | ||||||
| ms.prod | sql | ||||||
| ms.prod_service | database-engine, sql-database, synapse-analytics, pdw | ||||||
| ms.technology | 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 |
[!INCLUDE sql-asdb-asdbmi-asa-pdw]
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).
Transact-SQL Syntax Conventions
YEAR ( date )
[!INCLUDEsql-server-tsql-previous-offline-documentation]
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); 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);