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.


Year(date, [timezone])

Function arguments:

  • 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.

Related Functions

Was this page helpful?
Yes No