If you supply an optional unit string, x is rounded to that unit;In the following example, YYYY rounds x to the first day of the nearest year. SQL>SQL> SELECT ROUND(TO_DATE('25-OCT-2005'), 'YYYY') FROM dual;ROUND(TO_---------01-JAN-06