SELECT CONCAT('Q',QUARTER(`Date`), ' ',YEAR(`Date`)) FROM datetable ORDER BY `Date`; | CONCAT('Q',QUARTER(`Date`), ' ',YEAR(`Date`)) | | --------------------------------------------- | | Q1 2011 | | Q2 2011 | | Q3 2011 | | Q4 2011 | | Q1 2012 | | Q2 2012 | | Q3 2012 | | Q4 2012 | | Q1 2013 | | Q2 2013 | | Q3 2013 | | Q4 2013 |