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 |
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter