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