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?