ROUND (date)

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.