Query Run
select SUBSTRING(log_timestamp,1,8) as day, count(*) from logging where... 7 years ago
select SUBSTRING(log_timestamp,1,8) as day, count(*) from logging where... 7 years ago
select DATE_FORMAT(log_timestamp,'%m-%d-%Y') as day, count(*) from logging... 7 years ago
select SUBSTRING(log_timestamp,1,8) as day, count(*) from logging where... 7 years ago