title: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value in SQL Server 2005
body: <p>I have written a view in which date from table which is converted as </p>
  
  <pre><code>convert(varchar, date, 103) 
  </code></pre>
  
  <p>and taken alias as DATE1 and then I have written query as follows :</p>
  
  <pre><code>select DATE1  
  from date_demo
  WHERE  MONTH(DATE1) = '12'
  </code></pre>
  
  <p>I want to retrieve only specific records with the month = 'december' that is 12 </p>
  
  <p>I got an error:</p>
  
  <blockquote>
    <p>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. </p>
  </blockquote>
  
  <p>This is in SQL Server 2005 pls help me </p>