Query Run
select substring( rev_timestamp from 9 for 2 ) as hour, ... 8 months ago
select substring( rev_timestamp from 9 for 2 ) as hour, ... 8 months ago