TD_YEAR_BEGIN_UDF

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

Definition

User-defined function (UDF) that reproduces the functionality of TD_YEAR_BEGIN or TD_YEAR_BEGIN( DATE, 'COMPATIBLE').

PUBLIC.TD_YEAR_BEGIN_UDF(INPUT DATE)

Parameters

INPUT DATE

The date to get the first day of the year.

Returns

The first day of the year.

Usage example

Input:

SELECT TD_YEAR_BEGIN(DATE '2022-01-01', 'COMPATIBLE'),
TD_YEAR_BEGIN(DATE '2022-04-12');

Output:

2022-01-01, 2022-01-01