title: Oracle SQL first and last day of quarter of any year
body: <p>Is there any way i can calculate the first and last day of the three quarters in any year . 2012 , 2013 or 2014</p>
  
  <pre><code>SELECT ADD_MONTHS(TRUNC(SYSDATE, 'Q'), -3) AS First,
         TRUNC(SYSDATE, 'Q') - 1             AS Last
  FROM DUAL
  </code></pre>
  
  <p>calculates the first quarter of current year. i want to calculate the first quarter of any year ? </p>