2 Replies Latest reply: Jul 5, 2018 4:27 AM by Bala Bhaskar RSS

    Limit dates in Oracle

    Gowtham Kesavan

      I have a table in oracle db where the data is till 4th june 2018 but i want to load data till previous month last date so am using this condition in select

       

      Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss'))<'$(vMaxDate)'

       

      vMaxDate is having 01062018000000

       

      this is not working.

       

      Any other idea?