summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/sqlite.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2005-11-29 06:52:16 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2005-11-29 06:52:16 +0000
commit93398271ed4368de08738951c7040b2c15d286ae (patch)
tree2e74bdd68b88b0a2ac8f68b49b720a948bdaed8a /lib/sqlalchemy/databases/sqlite.py
parent92dc0d0dbda52a94911f858429a41b09b728ad52 (diff)
downloadsqlalchemy-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.py10
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])