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