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