MYSQL query Group by date/ month ./ year

Select * from `order` GROUP BY DATE(`date`) , MONTH(`date`), YEAR(`date`);