Oracle TRUNC Date Function By Practical Examples (oracletutorial.com)
| Format | Description |
|---|---|
| CC, SCC | Century, with or without minus sign (BC) |
| [S]YYYY, [S]YEAR, YYY, YY, Y | Year (in various appearances) |
| IYYY, IYY, IY, I | ISO year |
| Q | Quarter |
| MONTH, MON, MM, RM | Month (full name, abbreviated name, numeric, Roman numerals) |
| IW, WW (ISO) | week number |
| W | Day of the week |
| DDD, DD, J | Day (of the year/of the month/Julian day) |
| DAY, DY, D | Closest Sunday |
| HH, HH12, HH24 | Hours |
| MI | Minutes |
