Oracle ROUND function (FOR DATE).

Preamble

The Oracle/PLSQL ROUND function returns a date rounded to a specific unit.

Oracle/PLSQL syntax of the ROUND function (for dates)

ROUND( date_id, [ format_id ] )

Parameters and function arguments

• date_id – date for rounding.
• format_id – the unit of measurement used for rounding. If the format parameter is omitted, ROUND rounds to the nearest day.

The acceptable format parameters are shown below:

The ROUND function (for dates) returns the date.

The ROUND function can be used in the following versions of Oracle/PLSQL

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Let’s consider some examples of the ROUND function and learn how to use the ROUND function in Oracle.

SELECT ROUND(TO_DATE ('31.07.2014'), 'YEAR') FROM DUAL;

--Result: 01.01.2015

SELECT ROUND(TO_DATE ('31.07.2014'), 'Q') FROM DUAL;

--Result: 01.07.2014

SELECT ROUND(TO_DATE ('31.07.2014'), 'MONTH') FROM DUAL;

--Result: 01.08.2014

SELECT ROUND(TO_DATE ('31.07.2014'), 'DDD') FROM DUAL;

--Result: 31.07.2014

SELECT ROUND(TO_DATE ('31.07.2014'), 'DAY') FROM DUAL;

--Result: 28.07.2014

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​