oracle date format in where example
Example 1: specific date format oracle
TO_CHAR (TO_DATE('0297','MM/YY'), 'MM/YY')
Example 2: date format in oracle
e.g., 01-JAN-17
TO_CHAR (TO_DATE('0297','MM/YY'), 'MM/YY')
e.g., 01-JAN-17