Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select last_day( date2000-02-01 ) Leap Yr

SQL> SQL> SQL> select last_day( date'2000-02-01' ) "Leap Yr?"   2  from dual; Leap Yr? --------- 29-FEB-00 1 row selected. SQL> SQL> --