title: SQL doesn't allow to cast date column to datetime?
body: <pre><code>Select * 
  from tableA 
  inner join tableB on tableA.id = tableB.aid 
                    and cast(a.date AS DATETIME) = CAST('2015-08-24' AS DATETIME) 
  </code></pre>
  
  <p>Values that stored in <code>tableA.date</code> are '2015-08-24' meaning data has no issue.</p>
  
  <p>When I execute the above statement, I get </p>
  
  <blockquote>
    <p>The conversion of a date data type to a datetime data type resulted in an out-of-range value</p>
  </blockquote>
  
  <p>May I know why cant cast a <code>date</code> column to <code>datetime</code>?</p>