JULIAN_TO_DATE_UDF

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');