0

Please login or register to vote for this query.

(click on this box to dismiss)

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'

fork query

edited nov 24 21

created nov 23 21 anonymous