select CAST( cast(DATEPART(YYYY, p3.CreationDate) as varc...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select CAST(
      cast(DATEPART(YYYY, p3.CreationDate) as varchar) + '-' + cast(DATEPART(MM, p3.CreationDate) as varchar) + '-01'
    as datetime) [Month], 

    1 as ccomment
 ,  p3.id as [Post Link]   
  from Posts p3 inner join comments c on c.postid=p3.id where p3.posttypeid=1  and p3.closeddate !='' and c.text like '%engineering%' 
  order by [Month] desc

Enter Parameters

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