SQL Server YEAR() Function

Posted by

SQL Server

YEAR()

Function

Example

Return the year part of a date:

SELECT YEAR(‘2017/08/25’) AS Year;


Definition and Usage

The YEAR() function returns the year part for a specified date.

Syntax

YEAR(

date

)

Parameter Values

Parameter Description

date
Required. The date or datetime to extract the
year from

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data
Warehouse, Parallel Data Warehouse

More Examples

Example

Return the year part of a date:

SELECT YEAR(‘1998/05/25 09:08’) AS Year;