In this article we wre going write a query to find last date of next month. See the below query.
Query :
Output :
Query :
SELECT TO_CHAR(TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE, 1))),'MM-DD-YYYY') AS LAST_DATE FROM DUAL ;
Output :
LAST_DATE |
---|
04-30-2016 |