[issue13568] sqlite3 convert_date error with DATE type
Gianluigi Tiesi
report at bugs.python.org
Fri Dec 9 18:57:23 CET 2011
New submission from Gianluigi Tiesi <sherpya at 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 <report at bugs.python.org>
<http://bugs.python.org/issue13568>
_______________________________________
More information about the Python-bugs-list
mailing list