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