LAST_DAY_DECEMBER_OF_ISO_UDF

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Definition

UDF that process the last day of December with ISO year. It is used to calculate the result of PUBLIC.YEAR_END_IDO_UDF.

PUBLIC.LAST_DAY_DECEMBER_OF_ISO_UDF(INPUT TIMESTAMP_TZ)

Parameters

INPUT TIMESTAMP_TZ

The date to get the last day of December using ISO year.

Returns

A date which is the last day of December using ISO year.

Usage example

Input:

SELECT PUBLIC.LAST_DAY_DECEMBER_OF_ISO_UDF(DATE '2022-01-01');

Output:

2021-12-31