DATE_TO_RR_FORMAT_UDF

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