#5365: sqlite3+DateField: field__year doesn't work.
--------------------------------------------------------+-------------------
Reporter: Jakub Wilk <[email protected]> | Owner: nobody
Status: reopened | Milestone:
Component: Database layer (models, ORM) | Version: SVN
Resolution: | Keywords: qs-rf
Stage: Unreviewed | Has_patch: 1
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 1 |
--------------------------------------------------------+-------------------
Changes (by anonymous):
* status: closed => reopened
* needs_better_patch: 0 => 1
* has_patch: 0 => 1
* resolution: duplicate =>
Comment:
in db/backends/sqlite3/base.py the time is incorrect.
{{{
def year_lookup_bounds(self, value):
first = '%s-01-01'
second = '%s-12-31 23:59:59.999999'
return [first % value, second % value]
}}}
the correct format is '%s-12-31'''T'''23:59:59.999999' according to
http://www.sqlite.org/lang_datefunc.html
the path of #3689 don't solve the problem
--
Ticket URL: <http://code.djangoproject.com/ticket/5365#comment:5>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
