|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
date rounded to the unit specified by the format model
fmt. If you omit
date is rounded to the nearest day.
"ROUND and TRUNC Date Functions" for the permitted format models to use in
The following example rounds a date to the first day of the following year: