Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select last_day( sysdate ) Last day of this month

SQL> SQL> select last_day( sysdate ) "Last day of this month"   2  from dual; Last day --------- 30-JUN-08 1 row selected. SQL> SQL> --