Opened 17 years ago

Closed 16 years ago

Last modified 13 years ago

#7546 closed (fixed)

Exact lookups on DateTimeField() with datetime.date object does not work

Reported by: John-Scott Atlakson Owned by: nobody
Component: Documentation Version: dev
Severity: Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

In http://www.djangoproject.com/documentation/db-api/ there are several examples of passing in datetime.date() objects (notice it's not a datetime.datetime() object) as lookup parameters on a DateTimeField(). See http://www.djangoproject.com/documentation/db-api/#spanning-multi-valued-relationships for one such example:

Blog.objects.filter(entry__headline__contains='Lennon',
        entry__pub_date=datetime.date.today())

The only way I've been able to get the intended behavior is through the use of the range lookup:

today = datetime.date(2008, 6, 26)
tomorrow = datetime.date(2005, 6, 27)
Blog.objects.filter(entry__headline__contains='Lennon', 
        entry__pub_date__range=(today, tomorrow))

I'm assuming this is just a documentation issue, rather than a query bug.

Attachments (1)

7546.diff (1.7 KB ) - added by Dan Watson 16 years ago.
doc update

Download all attachments as: .zip

Change History (6)

comment:1 by Marc Garcia, 17 years ago

milestone: 1.0

comment:2 by Dan Watson, 16 years ago

Has patch: set

Speaking to the author of this documentation (Malcolm wishes to remain nameless), this is indeed a documentation bug. Patch to follow.

by Dan Watson, 16 years ago

Attachment: 7546.diff added

doc update

comment:3 by anonymous, 16 years ago

Triage Stage: UnreviewedReady for checkin

comment:4 by Malcolm Tredinnick, 16 years ago

Resolution: fixed
Status: newclosed

(In [8232]) Fixed #7546 -- Fixed an incorrect example in the docs that was misleading some
people. Patch from Dan Watson.

comment:5 by Jacob, 13 years ago

milestone: 1.0

Milestone 1.0 deleted

Note: See TracTickets for help on using tickets.
Back to Top