TO_YEAR
Converts a date or timestamp (any date format we support) to a number containing the year.
Syntax
TO_YEAR(<date>)
Parameter | Description |
---|---|
<date> | The date or timestamp to be converted into the number of the year. |
Example
For Tuesday, April 22, 1975:
SELECT
TO_YEAR(CAST('1975/04/22' AS DATE)) as res;
Returns: 1975