Query Run
select distinct substring(log_timestamp, 1, 8) from logging_userindex ... 1 year ago
select distinct substring(log_timestamp, 1, 8) from logging_userindex ... 1 year ago