In this post I will show three different methods of representing the Date formats and a final screen show casing the final comparison of the three methods.
I am pulling four columns-
First is the original Date column
Second is the Evaluate Date column
Third is the Custom Date column
Fourth is the Cast Date column
First method- EVALUATE Function.
Second method- Changing with custom Date format in the Data format.
Third method- Casting with Date format.
And the final comparison of the above three methods.
And also try the below formatting in the RPD side-
-In the physical layer in the schema general properties-try to change the types after searching for DATE.
-the execute on connect of the connection pool write the below code-
ALTER SESSION SET NLS_DATE_FORMAT = 'MON-YYYY'
I am pulling four columns-
First is the original Date column
Second is the Evaluate Date column
Third is the Custom Date column
Fourth is the Cast Date column
First method- EVALUATE Function.
Second method- Changing with custom Date format in the Data format.
Third method- Casting with Date format.
And the final comparison of the above three methods.
And also try the below formatting in the RPD side-
-In the physical layer in the schema general properties-try to change the types after searching for DATE.
-the execute on connect of the connection pool write the below code-
ALTER SESSION SET NLS_DATE_FORMAT = 'MON-YYYY'
