select DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0) date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0) date
    , 'Python (Data Science)' programming_language
    , count(*) question_count
    , sum(viewcount) sum_viewcount
    , max(datediff(hour, creationdate, '2020-07-05 05:44:02')) hours_count
    , sum(viewcount/(datediff(hour, creationdate, '2020-07-05 05:44:02') / 24.0)) avg_viewcount
  from posts
  where posttypeid = 1
  and creationdate < '2020-07-01' --DATEADD(DAY, DATEDIFF(DAY, 0, getdate()) - 1, 0)
  and creationdate >= '2010-01-01'
  and (  tags like '%scikit-learn%'
      or tags like '%pytorch%'
      or tags like '%pyspark%' 
      or tags like '%theano%'
      or tags like '%numpy%'
      or tags like '%scipy%'
      or tags like '%pandas%' 
      or tags like '%scrapy%'
      or (tags like '%py%' and ( tags like '%keras%' 
                              or tags like '%tensorflow%'
                              or tags like '%machine-learning%'
                              or tags like '%deep-learning%'
                              or tags like '%h2o%'
                              or tags like '%artificial-intelligence%'
                               )
         )
      ) 
  group by DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results