title: How to get End date of last 12 months in Oracle
body: <p>I need a query where i can get last 12 month's end date  from the present system date in oracle . </p>
  
  <p>Below is the sample query i am using in Oracle</p>
  
  <pre><code>select
    trunc(add_months(sysdate,level-1),'MM') first_day,
    last_day(add_months(sysdate,level-1)) last_day
    from dual
  connect by level&lt;=12;
  </code></pre>