DATE_TO_RR_FORMAT_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 date to oracle RR datetime format date

PUBLIC.DATE_TO_RR_FORMAT_UDF(INPUT_DATE DATE)

Parameters

INPUT_DATE DATE

The date to transform.

Returns

The input date with years adjusted to RR format.

Migration example

Input:

IN -> Oracle_01.sql

Select TO_DATE('17-NOV-30','DD-MON-RR') as A from DUAL;

Output:

OUT -> Oracle_01.sql

Select
PUBLIC.DATE_TO_RR_FORMAT_UDF( TO_DATE('17-NOV-30', 'DD-MON-YY')) as A from DUAL;

Usage example

Input:

PUBLIC.CONVERT_DATE_WITH_RR_FORMAT_UDF(TO_DATE('17-NOV-30','DD-MON-YY')) as A from DUAL;

Output:

2030-11-17