title: SQL Server - The conversion of char data type to smalldatetime
body: <p>I was wondering if someone could help me.</p>
  
  <p>I have created a small SQL query, but every time I run it, I get the following error</p>
  
  <blockquote>
    <p>The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetype value.</p>
  </blockquote>
  
  <p>The SQL I'm trying to run is as follows:</p>
  
  <pre><code>UPDATE sales 
  SET dateOut = '2014-04-31 12:32:46' 
  WHERE userID = '11111' AND dateOut &gt;= '2014-04-01 12:32:46'
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>Cheers,</p>