title: What is SQL Server statement to get day and month ignoring the current year?
body: <p>I have table <code>HD_Case_Master</code> with a column <code>cm_date_created</code>.</p>
  
  <p>The example value is <code>2011-05-13 10:07:36.000</code>.</p>
  
  <p>I manage to get the current year but how to get record for all day and month.</p>
  
  <p>SQL statement:</p>
  
  <pre><code>SELECT 
      cm_create_date 
  FROM 
      HD_Case_Master 
  WHERE
      YEAR(cm_create_date) = YEAR(GETDATE()) AND ???
  </code></pre>