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