ROUND (date)

Syntax

round_date::=

Text description of round_date

Purpose

ROUND returns date rounded to the unit specified by the format model fmt. If you omit fmt, date is rounded to the nearest day.

See Also: "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt

Example

The following example rounds a date to the first day of the following year:

SELECT ROUND (TO_DATE ('27-OCT-00'),'YEAR')
   "New Year" FROM DUAL;
 
New Year
---------
01-JAN-01