DATE_TO_JULIAN_DAYS_UDF

Definition

This user-defined function (UDF) transforms from Gregorian date to Julian date (The number of days since January 1, 4712 BC.).

PUBLIC.DATE_TO_JULIAN_DAYS_UDF(INPUT_DATE DATE)

Parameters

INPUT_DATE DATE

The Gregorian date to transform.

Returns

Returns the date representation of the Julian date.

Migration example

Input:

IN -> Oracle_01.sql

Select TO_CHAR(SYSDATE, 'J') as A from DUAL;

Output:

OUT -> Oracle_01.sql

Select
PUBLIC.DATE_TO_JULIAN_DAYS_UDF(CURRENT_TIMESTAMP()) as A from DUAL;

Usage example

Input:

SELECT PUBLIC.DATE_TO_JULIAN_DAYS_UDF(DATE '1998-12-25');

Output:

2451173