1. MONTHS_BETWEEN with to_date function SQL> SQL> SELECT MONTHS_BETWEEN(TO_DATE('22SEP2006','ddMONyyyy'), 2 TO_DATE('13OCT2001','ddMONyyyy')) "Months difference" 3 FROM dual;Months difference ----------------- 59.2903226SQL> SQL> SQL>2. Converting spelled date to DATE format SQL> SQL> -- Converting spelled date to DATE format. SQL> SELECT TO_DATE('January 15','MONTH DD') "Sample" from DUAL;Sample --------- 15-JAN-06SQL>3. Converting number representation to DATE format SQL> SQL> -- Converting number representation to DATE format. SQL> SELECT TO_DATE('061167','MMDDYY') "Birthday" from DUAL;Birthday --------- 11-JUN-67SQL>4. TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-YY'), 'DD-MON-YYYY') SQL> SQL> SELECT TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-YY'), 'DD-MON-YYYY'), 2 TO_CHAR(TO_DATE('04-JUL-75', 'DD-MON-YY'), 'DD-MON-YYYY') 3 FROM dual;TO_CHAR(TO_ TO_CHAR(TO_ ----------- ----------- 04-JUL-2015 04-JUL-2075SQL> 5. 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-1975SQL>
SQL>
SQL> SELECT MONTHS_BETWEEN(TO_DATE('22SEP2006','ddMONyyyy'),
2 TO_DATE('13OCT2001','ddMONyyyy')) "Months difference"
3 FROM dual;Months difference
-----------------
59.2903226SQL>
SQL>
SQL>2. Converting spelled date to DATE format
SQL>
SQL> -- Converting spelled date to DATE format.
SQL> SELECT TO_DATE('January 15','MONTH DD') "Sample" from DUAL;Sample
---------
15-JAN-06SQL>3. Converting number representation to DATE format
SQL>
SQL> -- Converting number representation to DATE format.
SQL> SELECT TO_DATE('061167','MMDDYY') "Birthday" from DUAL;Birthday
---------
11-JUN-67SQL>4. TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-YY'), 'DD-MON-YYYY')
SQL>
SQL> SELECT TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-YY'), 'DD-MON-YYYY'),
2 TO_CHAR(TO_DATE('04-JUL-75', 'DD-MON-YY'), 'DD-MON-YYYY')
3 FROM dual;TO_CHAR(TO_ TO_CHAR(TO_
----------- -----------
04-JUL-2015 04-JUL-2075SQL>
5. 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-1975SQL>