Home Forums Data Warehousing Integration Services How to get first day of next month in variable RE: How to get first day of next month in variable

  • September 27, 2016 at 8:46 am

    #1903375

    SELECT ADD_MONTHS(TRUNC(sysdate, 'MONTH'), 1)

    FROM DUAL;