Last updated 1 year ago
Determines the year of a given date with a comma inserted between the first and second digits.
INPUT TIMESTAMP_TZ
INPUT
The date to get the year from.
Returns the year of a given date with a comma as varchar.
Input:
Output:
PUBLIC.YEAR_WITH_COMMA_UDF(INPUT TIMESTAMP_TZ)
SELECT PUBLIC.YEAR_WITH_COMMA_UDF(DATE '2021-10-26');
'2,021'