YEAR
Returns the year of a date or dateTime value. The year is returned as an integer in the range 1 - 9999.
Syntax
YEAR ( date | dateTime ) |
Inputs
- date or dateTime - The date or dateTime value of which the year must be returned.
Return type
- integer
Examples
| Expression | Result | Type |
|---|---|---|
| YEAR ( DATE ( 2015 , 01 , 01 ) ) | 2015 | Integer |
| YEAR ( DATE ( 1978 , 04 , 11 ) ) | 1978 | Integer |