New submission from Gianluigi Tiesi <sher...@gmail.com>: When using the 'DATE' datatype in a sqlite3 db and type converters are enabled the function in sqlite3/dbapi2.py fails
I'm not sure why sqlite3 returns something like 10-JAN-11, but the function expects a ts example: import sqlite3 d = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES) c = d.cursor() c.execute("create table testdate (t1 date)") c.execute("insert into testdate values ('now')") c.execute("select * from testdate") ---------- components: Library (Lib) messages: 149113 nosy: sherpya priority: normal severity: normal status: open title: sqlite3 convert_date error with DATE type type: behavior versions: Python 2.7 _______________________________________ Python tracker <rep...@bugs.python.org> <http://bugs.python.org/issue13568> _______________________________________ _______________________________________________ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com