https://sourceforge.net/p/python-sybase/bugs/43/2013-10-08T16:06:59.095000ZRecent changes to 43: Invalid microsecond conversion using DateTimeAsPython2013-10-08T16:06:59.095000Z2013-10-08T16:06:59.095000Zhttps://sourceforge.nethttps://sourceforge.netf61badab7adf4a3a45ae4ce3644da523079aa584

<div class="markdown_content"><p>When using <code>DateTimeAsPython</code> for my output map, I found that the microsecond value in <code>datetime.datetime</code> was 1000 times the value stored in the database. here's a patch:</p> <div class="codehilite"><pre><span class="gd">--- Sybase.py (revision xxx)</span> <span class="gi">+++ Sybase.py (working copy)</span> <span class="gu">@@ -197,10 +197,10 @@</span> DateTimeAsPython = { CS_DATETIME_TYPE: lambda val: datetime.datetime(val.year, val.month + 1, val.day, val.hour, val.minute, <span class="gd">- val.second, val.msecond * 1000),</span> <span class="gi">+ val.second, val.msecond),</span> CS_DATETIME4_TYPE: lambda val: datetime.datetime(val.year, val.month + 1, val.day, val.hour, val.minute, <span class="gd">- val.second, val.msecond * 1000) }</span> <span class="gi">+ val.second, val.msecond) }</span> if _have_cs_date_type: DateTimeAsPython.update({ CS_DATE_TYPE: lambda val: datetime.date(val.year, val.month + 1, val.day) }) </pre></div> <p>Additional note: <code>DateTimeAsPython</code> also raises an error if the datetime field is NULL, probably not the desired behavior.</p></div>