Format Models
Date Format Models
| Element | Value Returned |
|---|---|
| - / , . ; “text” | Quoted text and punctuation are reproduced in the result |
| AD A.D. | Indicates date that is AD. Periods optional |
| AM A.M. PM P.M. | Before or after noon. Periods optional |
| BC B.C. | Indicates date that is BC. Periods optional |
| CC SCC | Century (SCC precedes BC century with -) |
| D | The day of week (1–7) |
| DAY | The name of the day of the week (Monday, Tuesday, etc.). Padded to 9 characters. |
| DD | Day of month (1–31) |
| DDD | The number of the day of year (1–366) |
| DY | The name of the day of the week, abbreviated |
| E | Abbreviated era name (for Japanese Imperial, ROC Official, and Thai Buddha calendars) |
| EE | Full era name |
| FF [1–9] | Fractional seconds. 1–9 specifies the number of digits |
| HH | Hour of day(12-hour ... |
Get Oracle® DBA SQL Quick Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
