title: Not able to find out of range value for a table column of Date type
body: <p>Executing the query <code>DBCC CHECKDB WITH NO_INFOMSGS</code> failed with the following error: </p>
  
  <blockquote>
    <p><em>Page (1:2772455), slot 8 in object ID 689489585, index ID 1,
    partition ID 72057594305052672, alloc unit ID 72057594619953152 (type
    "In-row data"). Column "Date" value is out of range for data type
    "datetime".</em></p>
  </blockquote>
  
  <p>Update column to a legal value.</p>
  
  <p>I got above message while running <code>DBCC checkDB</code> command for a specific table of a database 
  and when I tried to fetch the date column of that table by running below query:-</p>
  
  <pre><code>select [date] 
  from  [TableName] 
  where [Year] = 2011 
    and Month = 1 
    and [Date] &lt; '1753-01-01'
    and Date &gt; '9999-12-31'
  </code></pre>