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 |