title: Error converting dbtype_dbdate to date
body: <p>I have an ODBC data source set up as a linked server in MS SQL Server 2012.  Throughout this database, most (but not all) columns whose data type is date give me trouble whenever I run queries.  I do not have any trouble querying any columns other than these date type columns.</p>
  
  <p>The following query:</p>
  
  <pre><code>SELECT *
  FROM   OPENQUERY(LINKEDSERVERNAME, 'SELECT Product, 
                                             DateLastReceipt
                                      FROM   ProductTable')
  </code></pre>
  
  <p>Gives the following error message in SQL Server Management Studio (2012):</p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 10, Line 1.  Error converting data type DBTYPE_DBDATE to date.</p>
  </blockquote>
  
  <p>I have tried using CONVERT to convert the datatype to varchar per the following discussion without any luck (same error message):  <a href="http://social.technet.microsoft.com/Forums/en-US/transactsql/thread/3a7d94ee-46a0-40ce-ae95-127ec462fbff" rel="nofollow">http://social.technet.microsoft.com/Forums/en-US/transactsql/thread/3a7d94ee-46a0-40ce-ae95-127ec462fbff</a></p>
  
  <p>Now, there are some columns of the exact same data type (date) that do not give me any trouble at all.  In my ProductTable, for example, there is a column called AddedToFile that shows the date that the record was created.  This column gives me no trouble at all. </p>
  
  <p>Any help someone could offer would be MUCH appreciated.</p>
  
  <p>Thanks.</p>