[issue13568] sqlite3 convert_date error with DATE type
Gianluigi Tiesi added the comment: So I suppose I have to blame sqlite3 and not fill a bug here -- resolution: -> invalid status: open -> closed ___ Python tracker <http://bugs.python.org/issue13568> ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue13568] sqlite3 convert_date error with DATE type
Gianluigi Tiesi added the comment: I've made a simplified testcase, my problem is importing from a sql dump with dates in the format '10-OCT-11', so if I understand 'DATE' in sqlite is fake and really a string? I have no way to control this behavior if my dump is text? -- ___ Python tracker <http://bugs.python.org/issue13568> ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue13568] sqlite3 convert_date error with DATE type
New submission from Gianluigi Tiesi :
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
<http://bugs.python.org/issue13568>
___
___
Python-bugs-list mailing list
Unsubscribe:
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
