title: Adding 1 year to the sysdate
body: <p>I am trying to write a stored procedure to print the last day of month exactly next year</p>
  
  <p>I am getting this years last date, but I want 30/8/2014</p>
  
  <p>I already tried the following:</p>
  
  <pre><code>IF LAST_DAY( add_months( SYSDATE, 12 )-1)
  </code></pre>
  
  <p>But it didn't give me any output.</p>