title: How do I get the first date of a quarter in MySQL?
body: <p>The code that I have so far is below: I'm trying to find out what to put in place of my ?'s to find the start date of the quarter the date lies in.</p>
  
  <pre><code>SELECT
   QUARTER(r.callDate) AS quar,
   YEAR(r.callDate) AS ryear,
   ???????? AS scoreDateStart,
   (SELECT DATE (DATE_SUB( DATE_ADD( CONCAT( YEAR( r.callDate ), '-01-01'), INTERVAL QUARTER(r.callDate) QUARTER ), INTERVAL 1 DAY))) AS scoreDateEnd,
   group_concat(DISTINCT(r.resultId) separator ', ') AS resultIds
  FROM results AS r
  GROUP BY  quar, ryear
  ORDER BY quar;
  </code></pre>
  
  <p>I have tried Googling but to no avail.</p>
  
  <p>An example of the output would be:</p>
  
  <pre><code>'1', '2012', '2012-01-01', '2012-03-31', '57, 58, 59'
  '2', '2012', '2012-04-01', '2012-06-30', '10549, 10551, 12598'
  </code></pre>