YEAR(DT)

 

Description

This function returns the year component of the datetime value DT, where 1900 = 0.

 

Parameters

 

DT

A datetime value.

 

Examples

 

YEAR(24203) = 66

Where 24203 represents April 6, 1966.

 

YEAR(TODAY) = 90

Where TODAY = December 25, 1990.

 

YEAR(366) = 0

Where 366 represents December 31, 1900.