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 |
Get last date of next month in sql
In this article we wre going write a query to find last date of next month. See the below query.
Query :
Output :
Query :
Output :
