want today's date output for my procedure : My Store procedure :

    WITH dates
    AS
      (SELECT (dt + level - 1) AS etadate
      FROM
        (SELECT TRUNC(DATE '2018-09-01', 'MM') - 1 AS dt FROM DUAL
        ) d
        CONNECT BY LEVEL <= sysdate - dt + 1
      )
    SELECT TO_CHAR(TO_DATE(d.etadate,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YY')           AS DATEFORM,
      COALESCE(nsp.YNAME, LAG(nsp.YNAME IGNORE NULLS) OVER (ORDER BY d.etadate))         AS YNAME,
      COALESCE(nsp.CATEGORY, LAG(nsp.CATEGORY IGNORE NULLS) OVER (ORDER BY d.etadate))           AS CATEGORY,
      COALESCE(nsp.TYPE, LAG(nsp.TYPE IGNORE NULLS) OVER (ORDER BY d.etadate)) AS TYPE,
      COALESCE(nsp.STOCK_BALANCE, LAG(nsp.STOCK_BALANCE IGNORE NULLS) OVER (ORDER BY d.etadate)) AS STOCK_BALANCE
    FROM dates d
    LEFT JOIN VW_NET_STOCK_POSITION nsp 
     ON d.etadate = TRUNC(nsp.LAST_UPD_IS)

and ouput :

[![output][1]][1]


  [1]: https://i.stack.imgur.com/CMeCM.png


Now, i want only that output which contains today's date.not all date's records. so output should be last record of this output as todays date is 6th oct 2018.