![]() Previous |
![]() Next |
ROUND
returns a date rounded to the unit specified by the date format.
Return Value
DATE
Syntax
ROUND(date [, fmt ])
Arguments
date
is an expression that identifies a date and time.
fmt
is a text literal with a date format, as described in the Oracle Database SQL Language Reference.
Examples
ROUND(SYSDATE, 'YEAR')
returns the value 01-JAN-07
for any day in the last half of 2006.
ROUND(TO_DATE('13-OCT-06'), 'MONTH')
returns the value 01-OCT-06
.