PPT Slide

Using the last_day( ) function

in SELECT statements:

The function last_day( ) helps to determine

the date for the last date in the month for

the date given:

SELECT LAST_DAY('15-MAR-00') FROM DUAL;LAST_DAY('15-M --------------31-MAR-00