Query Run
select substring(rev_timestamp, 1, 6) as... 1 year ago
select substring(rev_timestamp, 1, 6) as... 1 year ago