Query Run
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour,... 6 months ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour,... 6 months ago