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

Question

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 1

YourModel.objects.filter(datetime_published__year='2008', 
                         datetime_published__month='03', 
                         datetime_published__day='27')

// edit after comments

YourModel.objects.filter(datetime_published=datetime(2008, 03, 27))

doest not work because it creates a datetime object with time values set to 0, so the time in database doesn't match.

Answer 2

See the article Django Documentation

Its very similar to the JZ answer

ur_data_model.objects.filter(ur_date_field=datetime(2005, 7, 27)

Answer 3

E.

Model.objects.filter(datetime__year=date.year, datetime__month=date.month, datetime__day=date.day)

prove it to yourself with today() method:

    >>>Model.objects.filter(datetime__year=datetime.date.today().year).filter(datetime__month=datetime.date.today().month).filter(datetime__day=datetime.date.today().day)

Answer 4

Such lookups are implmented 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.

Answer 5

This produces the same results as using __year, __month, and __day and seems to work for me:

YourModel.objects.filter(your_datetime_field__startswith=datetime.date(2009,8,22))

Answer 6

Hm.. My solution is working:

Mymodel.objects.filter(date_time_field__startswith=datetime.datetime(1986, 7, 28))