select round( sysdate, 'q' ) "Quarter"
SQL> SQL> SQL> select round( sysdate, 'q' ) "Quarter" 2 from dual 3 / Quarter --------- 01-JUL-08 1 row selected. SQL> SQL> SQL> --