| 10. 7. Date Format |
| 10. 7. 1. | Insert Date value with default format | | |
| 10. 7. 2. | By default, the database outputs dates in the format DD-MON-YY | | |
| 10. 7. 3. | Datetime Formatting Parameters for TO_CHAR() function | | |
| 10. 7. 4. | SELECT TO_CHAR(ADD_MONTHS(TO_DATE('01-JAN-2005 19:15:26','DD-MON-YYYY HH24:MI:SS'), 2), 'DD-MON-YYYY HH24:MI:SS') FROM dual; | | |
| 10. 7. 5. | CC: Two-digit century | | |
| 10. 7. 6. | SCC: Two-digit century with a negative sign (-) for B.C. | | |
| 10. 7. 7. | Q: One-digit quarter of the year | | |
| 10. 7. 8. | YYYY: All four digits of the year | | |
| 10. 7. 9. | IYYY: All four digits of the ISO year | | |
| 10. 7. 10. | RRRR: All four digits of the rounded year, which depends on the current year | | |
| 10. 7. 11. | SYYYY: All four digits of the year with a negative sign (-) for B.C. | | |
| 10. 7. 12. | Y,YYY: All four digits of the year with a comma | | |
| 10. 7. 13. | YYY: Last three digits of the year | | |
| 10. 7. 14. | IYY: Last three digits of the ISO year | | |
| 10. 7. 15. | YY: Last two digits of the year | | |
| 10. 7. 16. | IY: Last two digits of the ISO year | | |
| 10. 7. 17. | RR: Last two digits of the rounded year, which depends on the current year | | |
| 10. 7. 18. | Y: Last digit of the year | | |
| 10. 7. 19. | I: Last digit of the ISO year | | |
| 10. 7. 20. | YEAR: Name of the year in uppercase | | |
| 10. 7. 21. | Year: Name of the year with the first letter in uppercase | | |
| 10. 7. 22. | MM: Two-digit month of the year | | |
| 10. 7. 23. | MONTH: Full name of the month in uppercase, right-padded with spaces to a total length of nine characters | | |
| 10. 7. 24. | Month: Full name of the month with first letter in uppercase, right-padded with spaces to a total length of nine characters | | |
| 10. 7. 25. | MON: First three letters of the name of the month in uppercase | | |
| 10. 7. 26. | Mon: First three letters of the name of the month with the first letter in uppercase | | |
| 10. 7. 27. | RM:Roman numeral month. | | |
| 10. 7. 28. | WW: Two-digit week of the year | | |
| 10. 7. 29. | IW: Two-digit ISO week of the year | | |
| 10. 7. 30. | W: One-digit week of the month | | |
| 10. 7. 31. | DDD: Three-digit day of the year | | |
| 10. 7. 32. | DD:Two-digit day of the month | | |
| 10. 7. 33. | D: One-digit day of the week | | |
| 10. 7. 34. | DAY: Full name of the day in uppercase | | |
| 10. 7. 35. | Day: Full name of the day with the first letter in uppercase | | |
| 10. 7. 36. | DY: First three letters of the name of the day in uppercase | | |
| 10. 7. 37. | Dy: First three letters of the name of the day with the first letter in uppercase | | |
| 10. 7. 38. | J: Julian day-the number of days that have passed since January 1, 4713 B.C. | | |
| 10. 7. 39. | HH24: Two-digit hour in 24-hour format | | |
| 10. 7. 40. | HH: Two-digit hour in 12-hour format | | |
| 10. 7. 41. | MI: Two-digit minute | | |
| 10. 7. 42. | SS: Two-digit second | | |
| 10. 7. 43. | -/,.;: 'text' | | |
| 10. 7. 44. | SELECT TO_CHAR(SYSDATE, 'DD/MM/YYYY') | | |
| 10. 7. 45. | AM or PM: AM or PM as appropriate | | |
| 10. 7. 46. | SELECT TO_CHAR(SYSDATE, 'PM') | | |
| 10. 7. 47. | A.M. or P.M.: A.M. or P.M. as appropriate (2) | | |
| 10. 7. 48. | SELECT TO_CHAR(SYSDATE, 'P.M.') (2) | | |
| 10. 7. 49. | AD or BC: AD or BC as appropriate | | |
| 10. 7. 50. | TO_CHAR(SYSDATE, 'BC') | | |
| 10. 7. 51. | A.D. or B.C.: A.D. or B.C. as appropriate (2) | | |
| 10. 7. 52. | TO_CHAR(SYSDATE, 'B.C.') (2) | | |
| 10. 7. 53. | DDSPTH 'of' MONTH, YEAR A.D. | | |
| 10. 7. 54. | DAY MON, YY AD | | |
| 10. 7. 55. | SELECT TO_CHAR(TO_DATE('05-FEB-1968'), 'MONTH DD, YYYY') | | |