JULIAN_TO_DATE_UDF

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

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:

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

Output:

SELECT
PUBLIC.JULIAN_TO_DATE_UDF('2020002') /*** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'JULIAN_TO_DATE_UDF' INSERTED. ***/;