sql - datepart year AND quarter in one column in MySQL

Question

I need to parse out the year and quarter from the Date column. My data looks like this:

Feb 1, 2019
Feb 2, 2019

Desired output is:

2019, 1
2019, 1

I have tried:

QUARTER(`Date`)

But this only gives me back the quarter 1. Can't find a way to include both year and the quarter. Thank you!

question from:https://stackoverflow.com/questions/65904382/datepart-year-and-quarter-in-one-column-in-mysql

Answer 1

You can use CONCAT to show both year and quarter

SELECT CONCAT(YEAR("2017-06-15"), ", ", QUARTER("2017-06-15"));