i given table with a timestamp on each row, which are query used to fit into this specific json object format.
I want to organize a json object into years / months.but ima failled.
i am using this code.there something fault .
json based query off
"2016":["January", "February", "December"]
query is here
i am using this query.
MONTHNAME(summaryDateTime) as month, YEAR(t.summaryDateTime) as year
GROUP BY EXTRACT(YEAR_MONTH FROM summaryDateTime) DESC";