13. 21. TO_DATE |
| 13. 21. 1. | Specifying a Datetime Format for TO_DATE() function | | |
| 13. 21. 2. | Using the YY Format | | |
| 13. 21. 3. | Using the RR Format | | |
| 13. 21. 4. | TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-RR'), 'DD-MON-YYYY') | | |
| 13. 21. 5. | TO_DATE function to convert from characters to dates explicitly | | |
| 13. 21. 6. | TO_DATE(x[, format]) converts the x string to a datetime | | |
| 13. 21. 7. | TO_DATE() converts the strings 04-JUL-2006 to the date July 4, 2006 | | |
| 13. 21. 8. | Specifying Times | | |
| 13. 21. 9. | TO_DATE() with INSERT statement | | |
| 13. 21. 10. | DBMS_OUTPUT.PUT_LINE(TO_DATE ('1/1')); | | |
| 13. 21. 11. | DBMS_OUTPUT.PUT_LINE(TO_DATE ('6/1996')); | | |
| 13. 21. 12. | DBMS_OUTPUT.PUT_LINE(TO_DATE ('12-APR-09')); | | |
| 13. 21. 13. | DBMS_OUTPUT.PUT_LINE(TO_DATE ('19991205')); | | |
| 13. 21. 14. | DBMS_OUTPUT.PUT_LINE(TO_DATE ('1/1/1')) | | |
| 13. 21. 15. | Birthday before 1940 | | |
| 13. 21. 16. | Catch exception from to_date function | | |