title: MS SQL - yyyyDDmm date format in WHERE clause
body: <p>How to use <code>WHERE</code> clause for <code>yyyyMMdd</code> date format if I need to filter rows, where is <code>yyyy-MM-dd hh:mm:ss.mmm</code> datetime format?</p>
  
  <p>For example: <code>SELECT * FROM orders WHERE order_date = '20140510'</code></p>
  
  <p>By the way, this example works for rows, where is <code>yyyy-MM-dd 00:00:00.000</code> datetime format.</p>