commit 8b945148e3f98b9c6c51bfaa830e779979713b82
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:56 2013 +0100
tree 1a1a47af35e3a998dd59226f0b72b8a03c7ac55a
parent ed909bcbddfa9c956fbbbb4a1b6a375d3e0e6599

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 6c121a5..1048992 100644
--- a/Lib/sqlite3/dbapi2.py
+++ b/Lib/sqlite3/dbapi2.py
@@ -67,7 +67,7 @@
         timepart_full = timepart.split(b".")
         hours, minutes, seconds = map(int, timepart_full[0].split(b":"))
         if len(timepart_full) == 2:
-            microseconds = int(timepart_full[1])
+            microseconds = int('{:0<6}'.format(timepart_full[1].decode()))
         else:
             microseconds = 0