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 |