TD_YEAR_BEGIN_UDF

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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