title: How to SELECT year using a WHERE clause on a DateTime type column
body: <p>There is a table <code>Sales</code>with data from year 2005 to year 2015
  I want to query data and filter column <code>Sales_Date</code> with <code>datetime</code> data type where the year is 2013 including all other columns </p>
  
  <pre><code>     SELECT *
       FROM Sales
       WHERE Sales_Date BETWEEN '2013-01-01' AND '2014-01-01';
  </code></pre>
  
  <p>is this correct or there is a function specifically to filter query by year of <code>datetime</code> data type</p>