Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.