[New-bugs-announce] [issue13568] sqlite3 convert_date error with DATE type

[Gianluigi Tiesi]

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>
_______________________________________