select round( sysdate, 'year' )
SQL> SQL> select round( sysdate, 'year' ) 2 from dual 3 / ROUND(SYS --------- 01-JAN-08 1 row selected. SQL> SQL> SQL> --