YEAR
Last updated
Was this helpful?
Last updated
Was this helpful?
The function YEAR takes a date or a DateTime and retrieves the four-digit year.
This function takes either a single or a single as input. It then returns the four-digit year described by the input.
datetime (type: DateTime) A DateTime to retrieve the year from.
date (type: date) A date to retrieve the year from.
year (type: number) The 4-digit year described by the input.
Assume the first example has access to the following DateTime value:
The following example retrieves the 4-digit year described in the DateTime example_date_and_time. Note how the output matches the year given in the above variable.
The above example demonstrates how the YEAR function behaves when given a DateTime as input. In order to further establish how the YEAR function behaves when given a date as input, assume the last example has access to the following date value:
The following example retrieves the 4-digit year described in the DateTime example_date. Note that the date described in example_date is identical to the date described in example_date_and_time, and YEAR returns the same value when given either as input: