title: ValueError when reading dates from hfsql database using ODBC
body: <p>With some struggles I connected to a hfsql server using ODBC. I've tried both pypyodbc and pyodbc.
  My goal is to get some insights in the data (and visualize some aspects).</p>
  <p>For some planning visualization I need to read out some of the data, which works fine for most tables and columns. However, when I try to read out a column containing dates i get a ValueError:</p>
  <pre class="lang-none prettyprint-override"><code>    invalid literal for int() with base 10: ''
  </code></pre>
  <p>All rows contain a valid date.</p>
  <p>This is the code that currently produces the error above:</p>
  <pre><code>deadlines = db.cursor()
  query = (&quot;SELECT DeliveryDate FROM Orders WHERE Finished = 0&quot;)
  deadlines.execute(query)
  print(deadlines.fetchone()) #&lt;- this goes wrong
  </code></pre>
  <p>db is the database (it works with other queries)</p>
  <pre><code>    print(deadlines.description)
  </code></pre>
  <p>gives: [('deliverydate', &lt;class 'datetime.date'&gt;, 11, 9, 9, 0, True)]</p>
  <p>I also tried:</p>
  <pre><code>pandas.read_sql(query,db,parse_dates={'DeliveryDate': {&quot;dayfirst&quot;: True}})
  </code></pre>
  <p>(dates are e.g. 27-6-2022)
  Which unfortunately gives the same error.</p>
  <p>Any help would be appreciated,
  cheers,</p>