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 :

  SELECT TO_CHAR(TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE, 1))),'MM-DD-YYYY') AS  LAST_DATE FROM DUAL ;

Output :

LAST_DATE
04-30-2016