Filip GruszczyĆski grusz...@gmail.com added the comment:
c.execute(insert into testdate values ('now'))
This works, but you actually are putting string now into a field with DATE
type. When conversion occurs after retrieving data, there is an error. Also if
you use datetime() function
Gianluigi Tiesi sher...@gmail.com 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?
Gianluigi Tiesi sher...@gmail.com added the comment:
So I suppose I have to blame sqlite3 and not fill a bug here
--
resolution: - invalid
status: open - closed
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue13568
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 =