Trunc and round-Date Format models in Oracle

Round and trunc date functions

Table 7-13 lists the format models you can use withRoundAndTruncDate functions and the units to which they round and truncate dates. The default model, 'dd', returns the date rounded or truncated to the day with a time of midnight.

Table 7-13 Date Format models for the round and trunc date functions

Format Model	Rounding or truncating Unit
Ccscc	One greater than the first two digits of a four-digit year
Syyyyyyyyyearsyearyyyyyy	Year (rounds up on July 1)
Iyyyiyiyi	ISO year
Q	Quarter (rounds up on the sixteenth day of the second month of the quarter)
Monthmonmmrm	Month (rounds up on the sixteenth day)
WW	Same day of the week as the first day of the year
IW	Same day of the week as the first day of the ISO year
W	Same day of the week as the first day of the month
Dddddj	Day
Daydyd	Starting day of the week
Hhhh12hh24	Hour
Mi	Minute

The starting day of the week used by the format models day, Dy, and D is specified implicitly by the initialization parameterNls_territory.