Find last day of the month in oracle

By Santhosh N

This explains how to get the last day of the month from the specified date in oracle

There is function by the name, LAST_DAY for fetching the last day of the month from the given date.

Syntax : LAST_DAY(DATE)

ex: SELECT TO_CHAR(LAST_DAY('29-APR-2010'),'MM/DD/YYYY HH:MM:SS AM') from DUAL;

Related FAQs

This explains how to find the number of months between two dates in oracle
This explains how to add the number of months to a given date in oracle
Find last day of the month in oracle  (1400 Views)