Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 78 of 121
ROUND
returns d rounded to the unit specified by the format model fmt. If you omit fmt, d is rounded to the nearest day. See "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt.
SELECT ROUND (TO_DATE ('27-OCT-92'),'YEAR')
"New Year" FROM DUAL;
New Year
---------
01-JAN-93
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|