4 Replies Latest reply: Oct 4, 2013 1:56 PM by ranit B RSS

    need records from the last month

    arizona9952

      Hi, using Oracle 11g R2.

      On the last day of each month of each year, I'd like to query data from a table over the last month. For example, if today is December 31st, 2013, I'd like to query only records with a settlement_dt between (and including) Dec 1, 2012 and Dec 31, 2012. My process will run automatically at the end of each month, so I can't hard code the date values. I've developed the following solution, but I was wondering if anyone had other ideas.

       

      TO_CHAR(io.settlement_dt, 'MON')||TO_CHAR(io.settlement_dt, 'YYYY') =

                                     TO_CHAR(SYSDATE, 'MON')||TO_CHAR(SYSDATE, 'YYYY')

       

      Thanks!