FIRST_DAY_JANUARY_OF_ISO_UDF

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

Definition

The first day of January with ISO year which is used to calculate the result of the PUBLIC.YEAR_BEGIN_ISO_UDF function.

FUNCTION PUBLIC.FIRST_DAY_JANUARY_OF_ISO_UDF(INPUT TIMESTAMP_TZ) 

Parameters

INPUT TIMESTAMP_TZ

The date to get January first using the ISO year.

Returns

A date which is the first day of January with ISO year.

Usage example

Input:

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

Output:

2021-01-01