Message 149113 - Python tracker

➜

This issue tracker has been migrated to GitHub , and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

In-reply-to
Author	sherpya
Recipients	sherpya
Date	2011年12月09日.17:57:22
SpamBayes Score	5.018951e-09
Marked as misclassified	No
Message-id	<1323453443.17.0.752390748467.issue13568@psf.upfronthosting.co.za>

Content
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")

Content

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")

History
Date	User	Action	Args
2011年12月09日 17:57:23	sherpya	set	recipients: + sherpya
2011年12月09日 17:57:23	sherpya	set	messageid: <1323453443.17.0.752390748467.issue13568@psf.upfronthosting.co.za>
2011年12月09日 17:57:22	sherpya	link	issue13568 messages
2011年12月09日 17:57:22	sherpya	create

homepage