YEAR

Syntax

YEAR(<date>)

Description

Returns the year corresponding to a date. The year is returned as an integer, ranging from 1900-9999.

Examples

Current date and time

YEAR returns

Oct 15, 2002 4:34:34 AM

2002

Sep 26, 2010 12:33:25 PM

2010

Aug 31, 2011 11:30:45 AM

2011