Opened 8 years ago

Closed 8 years ago

Last modified 5 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: master
Severity: Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

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 8 years ago.
doc update

Download all attachments as: .zip

Change History (6)

comment:1 Changed 8 years ago by Marc Garcia

milestone: 1.0

comment:2 Changed 8 years ago by Dan Watson

Has patch: set

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

Changed 8 years ago by Dan Watson

Attachment: 7546.diff added

doc update

comment:3 Changed 8 years ago by anonymous

Triage Stage: UnreviewedReady for checkin

comment:4 Changed 8 years ago by Malcolm Tredinnick

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 Changed 5 years ago by Jacob

milestone: 1.0

Milestone 1.0 deleted

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