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