DATE_TO_JULIAN_DAYS_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

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