select * from comments c where datediff(day, c.creationda...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
  *
from
  comments c
where
  datediff(day, c.creationdate, getdate()) <= 30 and
  c.text like N'%ಠ[_]ಠ%'  
order by
  c.creationdate desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results