Query Run
select DATENAME(WEEKDAY, left(rev_timestamp, 8)) as "day" from... 1 month ago