Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select round( sysdate, month )

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