SELECT LAST_DAY('15-MAR-00') FROM DUAL.
30-MAR-00
31-MAR-00
15-MAR-00
THERE IS NO FUNCTION LIKE LAST_DAY