Table 1

Oracle date format primitives.

Format Meaning
DDD Numeric day of year (1-365 or 366)
DD Numeric day of month (1-30 or 31)
D Numeric day of week (1-7)
DAY Full day name
DY Abbreviated day name
MM Two-digit month (01-12)
MONTH Full month name
MON Abbreviated month name
YY Two-digit year
YYYY Four-digit year
Q Quarter of year
W Week of month
WW Week of year