MySQL Query GROUP BY day / month / year September 8, 2022 by Tarik GROUP BY YEAR(record_date), MONTH(record_date) Check out the date and time functions in MySQL.