From 61859f21eb83468ba7a05298fe9930b4426bdf0a Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 16 Nov 2005 03:13:37 +0000 Subject: [PATCH] --- lib/sqlalchemy/databases/sqlite.py | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 53c5b771f5..860e82c2cd 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" -- 2.47.2