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 (1717 Views)