diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-11-29 06:52:16 +0000 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-11-29 06:52:16 +0000 |
commit | 93398271ed4368de08738951c7040b2c15d286ae (patch) | |
tree | 2e74bdd68b88b0a2ac8f68b49b720a948bdaed8a /lib/sqlalchemy/databases/sqlite.py | |
parent | 92dc0d0dbda52a94911f858429a41b09b728ad52 (diff) | |
download | sqlalchemy-93398271ed4368de08738951c7040b2c15d286ae.tar.gz |
fix to result processing of date types
Diffstat (limited to 'lib/sqlalchemy/databases/sqlite.py')
-rw-r--r-- | lib/sqlalchemy/databases/sqlite.py | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 9e945227e..de9acc17c 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -38,8 +38,14 @@ class SLDateTime(sqltypes.DateTime): def get_col_spec(self): return "TIMESTAMP" def convert_result_value(self, value): - (value, microsecond) = value.split('.') - microsecond = int(microsecond) + if value is None: + return None + parts = value.split('.') + try: + (value, microsecond) = value.split('.') + microsecond = int(microsecond) + except ValueError: + (value, microsecond) = (value, 0) tup = time.strptime(value, "%Y-%m-%d %H:%M:%S") return datetime.datetime(microsecond=microsecond, *tup[0:6]) |