Q&A about the site for Drupal developers and administrators
SET DATEFIRST 2 select count(text) as numberofcomments, datepart(weekday,creationdate) as dayofweek from comments where creationdate between '2021-11-01' and '2021-11-07' group by datepart(dw,creationdate); --, creationdate --select count(text) --from comments --where convert(date,creationdate) = '2021-11-07'-- and '2021-11-07'