Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 104 of 177
round_date::=
ROUND
returns date
rounded to the unit specified by the format model fmt
. If you omit fmt
, then date
is rounded to the nearest day.
See Also:
"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:
SELECT ROUND (TO_DATE ('27-OCT-00'),'YEAR') "New Year" FROM DUAL; New Year --------- 01-JAN-01
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|