title: SQL Server conversion issue with datetime
body: <p>I always use this code for conversion in datetime:</p>
  
  <pre><code> DECLARE @a datetime
   SET @a= CONVERT(datetime,'2012-12-28 14:04:43') 
   print @a
  </code></pre>
  
  <p>But this does not work anymore! I tried even restarting SQL Server, but the problem remains:</p>
  
  <p><img src="https://i.stack.imgur.com/fxHf7.jpg" alt="Conversion error"></p>
  
  <p>The error in the image is in Italian. In English should be:</p>
  
  <blockquote>
    <p><em>The conversion of a char data type to datetime resulted in a datetime
    value that is out of range of allowed values​​.</em></p>
  </blockquote>