The Year function returns an integer representing the year component of a specified date and time.
For more information (including use case exercises) about date functions, see the Common Date Functions and Use Cases QuickStart.
- date (required) - the date or column containing date values from which the year component is extracted
- timezone (optional) - the IANA time zone (e.g.,
“America/Los_Angeles”) to convert the date value to before extracting the year component
When the timezone argument is omitted, the input date is evaluated in UTC time.
Extracts the year component from the specified date (August 14, 2007) and returns
2007 to represent the year.