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

User · Answer

Here is an interesting technique-- I leveraged the startswith procedure as implemented with Django on MySQL to achieve the result of only looking up a datetime through only the date. Basically, when Django does the lookup in the database it has to do a string conversion for the DATETIME MySQL storage object, so you can filter on that, leaving out the timestamp portion of the date-- that way %LIKE% matches only the date object and you'll get every timestamp for the given date.

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

This will perform the following query:

SELECT (values) FROM myapp_my_object \ 
WHERE myapp_my_object.datetime_attr LIKE BINARY 2009-08-22%

The LIKE BINARY in this case will match everything for the date, no matter the timestamp. Including values like:

+---------------------+
| datetime_attr       |
+---------------------+
| 2009-08-22 11:05:08 |
+---------------------+

Hopefully this helps everyone until Django comes out with a solution!

User · Answer

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

User · Answer

Model objects filter datetime  year 2011  datetime  month 2  datetime  day 30

User · Answer

In Django 1 7 6 works   MyObject objects filter datetime attr  startswith datetime date 2009 8 22

User · Answer

Now Django has   date queryset filter to query datetime objects against dates in development version  Thus  it will be available in 1 9 soon

User · Answer

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

User · Answer

As of Django 1 9  the way to do this is by using   date on a datetime object   For example  MyObject objects filter datetime attr  date datetime date 2009 8 22

User · Answer

Mymodel objects filter date time field  contains datetime date 1986  7  28     the above is what I ve used  Not only does it work  it also has some inherent logical backing

User · Answer

See the article Django Documentation ur data model objects filter ur date field  gte datetime 2009  8  22   ur date field  lt datetime 2009  8  23

User · Answer

Hm   My solution is working   Mymodel objects filter date time field  startswith datetime datetime 1986  7  28

User · Answer

person   Profile objects get id 1   tasks   Task objects filter assigned to person  time stamp  year person time stamp utcnow   year   all my model do have time stamp so I used the person objects to obtain the current year

User · Answer

There s a fantastic blogpost that covers this here  Comparing Dates and Datetimes in the Django ORM  The best solution posted for Django 1 7  lt 1 9 is to register a transform   from django db import models  class MySQLDatetimeDate models Transform               This implements a custom SQL lookup when using    date  with datetimes      To enable filtering on datetimes that fall on a given date  import     this transform and register it with the DateTimeField              lookup name    date       def as sql self  compiler  connection           lhs  params   compiler compile self lhs          return  DATE      format lhs   params       property     def output field self           return models DateField     Then you can use it in your filters like this   Foo objects filter created on  date date    EDIT  This solution is definitely back end dependent  From the article      Of course  this implementation relies on your particular flavor of SQL having a DATE   function  MySQL does  So does SQLite  On the other hand  I haven   t worked with PostgreSQL personally  but some googling leads me to believe that it does not have a DATE   function  So an implementation this simple seems like it will necessarily be somewhat backend-dependent

User · Answer

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

User · Answer

Here are the results I got with ipython s timeit function   from datetime import date today   date today    timeit Model objects filter date created  year today year  date created  month today month  date created  day today day   1000 loops  best of 3  652 us per loop  timeit Model objects filter date created  gte today   1000 loops  best of 3  631 us per loop  timeit Model objects filter date created  startswith today   1000 loops  best of 3  541 us per loop  timeit Model objects filter date created  contains today   1000 loops  best of 3  536 us per loop   contains seems to be faster

User · Answer

assuming active on is a date object  increment it by 1 day then do  range   next day   active on   datetime timedelta 1  queryset   queryset filter date created  range  active on  next day

[python] How can I filter a date of a DateTimeField in Django?

Examples related to python

Examples related to django

Examples related to datetime

Examples related to filter

Examples related to django-queryset