|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 101 of 166
ROUND returns date rounded to the unit specified by the format model fmt. If you omit fmt, date is rounded to the nearest day.
"ROUND and TRUNC Date Functions" for the permitted format models to use in fmt
The following example rounds a date to the first day of the following year: