| description | YEAR (Transact-SQL) | ||||||
|---|---|---|---|---|---|---|---|
| title | YEAR (Transact-SQL) | Microsoft Docs | ||||||
| ms.custom | |||||||
| ms.date | 03/14/2017 | ||||||
| ms.prod | sql | ||||||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | ||||||
| ms.reviewer | |||||||
| ms.technology | t-sql | ||||||
| ms.topic | reference | ||||||
| f1_keywords |
|
||||||
| dev_langs |
|
||||||
| helpviewer_keywords |
|
||||||
| ms.assetid | 74aa7ccc-8575-4018-80cf-14aeca379687 | ||||||
| author | julieMSFT | ||||||
| ms.author | jrasnick | ||||||
| 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);