Query Run
SELECT CAST(CONCAT(LEFT(rev_timestamp, 12), '00') AS DATETIME) AS 'minute', ... 1 year ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 12), '00') AS DATETIME) AS 'minute', ... 1 year ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 12), '00') AS DATETIME) AS 'minute', ... 1 year ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour,... 1 year ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour,... 1 year ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour,... 1 year ago
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour,... 1 year ago