SELECT
(CONCAT( MONTH(date_time), "/", DAYOFMONTH(date_time) ,"/", YEAR(date_time))) as date,
COUNT(*) as visits
FROM metrics_session mGROUP BY YEAR(date_time), MONTH(date_time), DAYOFMONTH(date_time);
"Did you find this post useful? Sponsor marathon for cancer"