Query Run
select DAYNAME(left(rev_timestamp, 8)) AS DayName, left(rev_timestamp, 4) as... 6 months ago
select DAYNAME(left(rev_timestamp, 8)) AS DayName, left(rev_timestamp, 4) as... 6 months ago