title: SQL - Proper "where" clause for current month
body: <p>Which is the proper way of checking events from current month on SQL Server and why?</p>
  
  <p>1) <code>WHERE (DATEDIFF(month, EventTime, GETDATE())=0))</code></p>
  
  <p>2) <code>WHERE (YEAR(EventTime) = YEAR(GETDATE()) AND MONTH(EventTime) = MONTH(GETDATE()))</code></p>
  
  <p>Date format in table is i.e. <code>EventTime: 2011-11-30 15:68:25.000</code></p>