1 files changed, 7 insertions, 0 deletions

diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py
index 53c5b771f..860e82c2c 100644
--- a/lib/sqlalchemy/databases/sqlite.py
+++ b/lib/sqlalchemy/databases/sqlite.py
@@ -24,6 +24,7 @@ import sqlalchemy.schema as schema
 import sqlalchemy.ansisql as ansisql
 import sqlalchemy.types as sqltypes
 from sqlalchemy.ansisql import *
+import datetime,time
 
 from pysqlite2 import dbapi2 as sqlite
 
@@ -36,6 +37,12 @@ class SLInteger(sqltypes.Integer):
 class SLDateTime(sqltypes.DateTime):
     def get_col_spec(self):
         return "TIMESTAMP"
+    def convert_result_value(self, value):
+        (value, microsecond) = value.split('.')
+        microsecond = int(microsecond)
+        tup = time.strptime(value, "%Y-%m-%d %H:%M:%S")
+        return datetime.datetime(microsecond=microsecond, *tup[0:6])
+
 class SLText(sqltypes.TEXT):
     def get_col_spec(self):
         return "TEXT"