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 |