TO_DATE('04-JUL-15', 'DD-MON-RR'): Uses the RR format when interpreting the years 15 and 75 : TO_Date « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. TO_Date

TO_DATE('04-JUL-15', 'DD-MON-RR'): Uses the RR format when interpreting the years 15 and 75

 
SQL>
SQL> --Uses the RR format when interpreting the years 15 and 75
SQL>
SQL> SELECT
  2    TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-RR'), 'DD-MON-YYYY'),
  3    TO_CHAR(TO_DATE('04-JUL-75', 'DD-MON-RR'), 'DD-MON-YYYY')
  4  FROM dual;

TO_CHAR(TO_ TO_CHAR(TO_
----------- -----------
04-JUL-2015 04-JUL-1975

SQL>








Related examples in the same category

1.MONTHS_BETWEEN with to_date function
2.Converting spelled date to DATE format
3.Converting number representation to DATE format
4.TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-YY'), 'DD-MON-YYYY')
5.Use to_date function with between ... and