How can I filter a date of a DateTimeField in Django?

python django datetime filter django-queryset
Xidobix picture Xidobix · Aug 23, 2009 · Viewed 187.2k times · Source

I am trying to filter a DateTimeField comparing with a date. I mean:

MyObject.objects.filter(datetime_attr=datetime.date(2009,8,22))

I get an empty queryset list as an answer because (I think) I am not considering time, but I want "any time".

Is there an easy way in Django for doing this?

I have the time in the datetime setted, it is not 00:00.

Answer

Piotr Czapla picture Piotr Czapla · Dec 29, 2009

Such lookups are implemented in django.views.generic.date_based as follows:

{'date_time_field__range': (datetime.datetime.combine(date, datetime.time.min),
                            datetime.datetime.combine(date, datetime.time.max))}

Because it is quite verbose there are plans to improve the syntax using __date operator. Check "#9596 Comparing a DateTimeField to a date is too hard" for more details.

Related questions

Django auto_now and auto_now_add

For Django 1.1. I have this in my models.py: class User(models.Model): created = models.DateTimeField(auto_now_add=True) modified = models.DateTimeField(auto_now=True) When updating a row I get: [Sun Nov 15 02:18:12 2009] [error] /home/ptarjan/projects/twitter-meme/django/…

Read More
Can't compare naive and aware datetime.now() <= challenge.datetime_end

I am trying to compare the current date and time with dates and times specified in models using comparison operators: if challenge.datetime_start <= datetime.now() <= challenge.datetime_end: The script errors out with: TypeError: can't compare offset-naive …

Read More
Converting timezone-aware datetime to local time in Python

How do you convert a timezone-aware datetime object to the equivalent non-timezone-aware datetime for the local timezone? My particular application uses Django (although, this is in reality a generic Python question): import iso8601 .... date_str="2010-10-30T17:21:12Z" .... d = …

Read More