JULIAN_TO_DATE_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 transforms a Julian Date (YYYYDDD) into a Gregorian date.

PUBLIC.JULIAN_TO_DATE_UDF(JULIAN_DATE CHAR(7))

Parameters

JULIAN_DATE CHAR

The Julian date to transform.

Returns

The date representation of the Julian date or null if conversion is not possible.

Usage example

Input:

SELECT JULIAN_TO_DATE_UDF('2022045');

Output:

'2022-02-14'

Migration example

Input:

IN -> Teradata_01.sql

SELECT TO_DATE('2020002', 'YYYYDDD');

Output:

OUT -> Teradata_01.sql

SELECT
PUBLIC.JULIAN_TO_DATE_UDF('2020002');