commit 9e14755b46c48207b44be92093ca2eae6ba22fac
author Petri Lehtinen <petri@digip.org> Sat Feb 23 19:05:09 2013 +0100
committer Petri Lehtinen <petri@digip.org> Sat Feb 23 19:05:09 2013 +0100
tree 1bbb90a9c86258902251605e9f64a7e841334376
parent c23178ba36097764bc3c1c33aa8dba2a0871e778

Issue #14720: sqlite3: Convert datetime microseconds correctly

Patch by Lowe Thiderman

Lib/sqlite3/dbapi2.py

diff --git a/Lib/sqlite3/dbapi2.py b/Lib/sqlite3/dbapi2.py
index 7eb28e8..be7a50a 100644
--- a/Lib/sqlite3/dbapi2.py
+++ b/Lib/sqlite3/dbapi2.py
@@ -68,7 +68,7 @@
         timepart_full = timepart.split(".")
         hours, minutes, seconds = map(int, timepart_full[0].split(":"))
         if len(timepart_full) == 2:
-            microseconds = int(timepart_full[1])
+            microseconds = int('{:0<6}'.format(timepart_full[1].decode()))
         else:
             microseconds = 0