Query Run
select count(*), FORMAT(CAST(left(rev_timestamp, 8) AS DATE), 'dddd') AS... 6 months ago
select count(*), DATENAME(WEEKDAY, CAST(left(rev_timestamp, 6) AS... 6 months ago
select count(*), FORMAT(CAST(left(rev_timestamp, 8) AS DATE),... 6 months ago
select count(*), day(rev_timestamp) AS "day", avg(hour(rev_timestamp)) from... 6 months ago
SELECT DATENAME(WEEKDAY, '2022-01-01'); 6 months ago
select DATENAME(WEEKDAY, left(rev_timestamp, 8)) as "day" from... 6 months ago
select count(*), day(rev_timestamp) AS "day", avg(hour(rev_timestamp)) from... 6 months ago