Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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> --