blocks|key|1256557|text|这样的查找在django.views.generic.date_based中实现如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1256558|{'date_time_field__range':+(datetime.datetime.combine(date,+datetime.time.min),
++++++++++++++++++++++++++++datetime.datetime.combine(date,+datetime.time.max))}+|code-block|syntax|javascript|1256559|因为它相当冗长，所以有计划使用__date运算符来改进语法。查看"#9596+Comparing+a+DateTimeField+to+a+date+is+too+hard“了解更多详细信息。|1256560|entityMap|0|LINK|mutability|MUTABLE|url|http://code.djangoproject.com/ticket/9596^0|6|V|0|0|F|6|X|1H|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

Such lookups are implemented in <code>django.views.generic.date_based</code> as follows:

<pre><code>{'date_time_field__range': (datetime.datetime.combine(date, datetime.time.min),
 datetime.datetime.combine(date, datetime.time.max))} 
</code></pre>

Because it is quite verbose there are plans to improve the syntax using <code>__date</code> operator. Check "<a href="http://code.djangoproject.com/ticket/9596" rel="noreferrer">#9596 Comparing a DateTimeField to a date is too hard</a>" for more details.

blocks|key|1256482|text|YourModel.objects.filter(datetime_published__year='2008',+
+++++++++++++++++++++++++datetime_published__month='03',+
+++++++++++++++++++++++++datetime_published__day='27')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1256483|//注释后编辑|unstyled|1256484|YourModel.objects.filter(datetime_published=datetime(2008,+03,+27))|1256485|doest不起作用，因为它创建了一个时间值设置为0的datetime对象，因此数据库中的时间不匹配。|1256486|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>YourModel.objects.filter(datetime_published__year='2008', 
 datetime_published__month='03', 
 datetime_published__day='27')
</code></pre>

// edit after comments

<pre><code>YourModel.objects.filter(datetime_published=datetime(2008, 03, 27))
</code></pre>

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

blocks|key|1471628|text|现在Django有了__date查询集过滤器来根据开发版本中的日期查询datetime对象。因此，它将很快在1.9中可用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1471629|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/dev/ref/models/querysets/#date^0|A|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Now Django has <a href="https://docs.djangoproject.com/en/dev/ref/models/querysets/#date" rel="noreferrer">__date</a> queryset filter to query datetime objects against dates in development version. Thus, it will be available in 1.9 soon.

blocks|key|1256746|text|Mymodel.objects.filter(date_time_field__contains=datetime.date(1986,+7,+28))|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1256747|以上就是我所使用的。它不仅有效，而且有一些内在的逻辑支持。|unstyled|1256748|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>Mymodel.objects.filter(date_time_field__contains=datetime.date(1986, 7, 28))
</code></pre>

the above is what I've used. Not only does it work, it also has some inherent logical backing.

blocks|key|1257056|text|从Django1.9开始，实现这一点的方法是在datetime对象上使用__date。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1257057|例如：MyObject.objects.filter(datetime_attr__date=datetime.date(2009,8,22))|1257058|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/1.9/ref/models/querysets/#date^0|10|6|10|6|0|0|3|1X|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

As of Django 1.9, the way to do this is by using <a href="https://docs.djangoproject.com/en/1.9/ref/models/querysets/#date" rel="noreferrer"><code>__date</code></a> on a datetime object.

For example:
<code>MyObject.objects.filter(datetime_attr__date=datetime.date(2009,8,22))</code>

blocks|key|1471321|text|这将产生与使用__year、__month和__day相同的结果，并且似乎适用于我：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1471322|YourModel.objects.filter(your_datetime_field__startswith=datetime.date(2009,8,22))|code-block|syntax|javascript|1471323|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

<pre><code>YourModel.objects.filter(your_datetime_field__startswith=datetime.date(2009,8,22))
</code></pre>

blocks|key|1256906|text|假设active_on是一个date对象，将其递增1天，然后执行range|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1256907|next_day+=+active_on+%2B+datetime.timedelta(1)
queryset+=+queryset.filter(date_created__range=(active_on,+next_day)+)|code-block|syntax|javascript|1256908|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

assuming active_on is a date object, increment it by 1 day then do range 

<pre><code>next_day = active_on + datetime.timedelta(1)
queryset = queryset.filter(date_created__range=(active_on, next_day) )
</code></pre>

blocks|key|1471845|text|你可以这样做|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1471846|MyObject.objects.filter(datetime_field__date=datetime.date(2009,8,22))|code-block|syntax|javascript|1471847|或者，如果您想在两个日期之间进行筛选|1471848|MyObject.objects.filter(
++++datetime_field__date__range=(datetime.date(2009,8,22),+datetime.date(2009,9,22))
)|1471849|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can do like this
<pre><code>MyObject.objects.filter(datetime_field__date=datetime.date(2009,8,22))
</code></pre>
or if you want to filter between 2 dates
<pre><code>MyObject.objects.filter(
 datetime_field__date__range=(datetime.date(2009,8,22), datetime.date(2009,9,22))
)
</code></pre>

blocks|key|1471507|text|这里有一个有趣的技巧--我利用MySQL上的Django实现的startswith过程来实现只在日期中查找日期时间的结果。基本上，当Django在数据库中执行查找时，它必须对DATETIME+MySQL存储对象进行字符串转换，因此您可以对此进行过滤，省略日期的时间戳部分--这样，%25LIKE%25只匹配date对象，您将获得给定日期的每个时间戳。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1471508|datetime_filter+=+datetime(2009,+8,+22)+
MyObject.objects.filter(datetime_attr__startswith=datetime_filter.date())|code-block|syntax|javascript|1471509|这将执行以下查询：|1471510|SELECT+(values)+FROM+myapp_my_object+\+
WHERE+myapp_my_object.datetime_attr+LIKE+BINARY+2009-08-22%25|1471511|本例中的LIKE二进制文件将匹配日期的所有内容，而不管时间戳是什么。包括如下值：|1471512|%2B---------------------%2B
%7C+datetime_attr+++++++%7C
%2B---------------------%2B
%7C+2009-08-22+11:05:08+%7C
%2B---------------------%2B|1471513|希望这对每个人都有帮助，直到Django拿出解决方案！|1471514|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

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. 

<pre><code>datetime_filter = datetime(2009, 8, 22) 
MyObject.objects.filter(datetime_attr__startswith=datetime_filter.date())
</code></pre>

This will perform the following query:

<pre><code>SELECT (values) FROM myapp_my_object \ 
WHERE myapp_my_object.datetime_attr LIKE BINARY 2009-08-22%
</code></pre>

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

<pre><code>+---------------------+
| datetime_attr |
+---------------------+
| 2009-08-22 11:05:08 |
+---------------------+
</code></pre>

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

blocks|key|1257349|text|您可以根据日期进行筛选，因为日期格式与django日期格式相同。默认格式为ISO+YYYY-MM-DD|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1257350|target_date+=+"2009-08-22"
qs+=+MyObject.objects.filter(datetime_attr__date=target_date)|code-block|syntax|javascript|1257351|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can filter by the Date as per as the date format is the same with your django date format. Default format is ISO YYYY-MM-DD
<pre><code>target_date = &quot;2009-08-22&quot;
qs = MyObject.objects.filter(datetime_attr__date=target_date)
</code></pre>

blocks|key|1471200|text|请参阅文章Django+Documentation|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1471201|ur_data_model.objects.filter(ur_date_field__gte=datetime(2009,+8,+22),+ur_date_field__lt=datetime(2009,+8,+23))|code-block|syntax|javascript|1471202|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/dev/ref/models/querysets/#gt^0|5|K|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

See the article <a href="https://docs.djangoproject.com/en/dev/ref/models/querysets/#gt" rel="nofollow noreferrer">Django Documentation</a>
<pre><code>ur_data_model.objects.filter(ur_date_field__gte=datetime(2009, 8, 22), ur_date_field__lt=datetime(2009, 8, 23))
</code></pre>

blocks|key|1256515|text|Model.objects.filter(datetime__year=2011,+datetime__month=2,+datetime__day=30)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1256516|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Model.objects.filter(datetime__year=2011, datetime__month=2, datetime__day=30)
</code></pre>

blocks|key|1256688|text|嗯..。我的解决方案正在发挥作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1256689|Mymodel.objects.filter(date_time_field__startswith=datetime.datetime(1986,+7,+28))|code-block|syntax|javascript|1256690|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Hm.. My solution is working:

<pre><code>Mymodel.objects.filter(date_time_field__startswith=datetime.datetime(1986, 7, 28))
</code></pre>

blocks|key|1257100|text|在Django+1.7.6中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1257101|MyObject.objects.filter(datetime_attr__startswith=datetime.date(2009,8,22))|code-block|syntax|javascript|1257102|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In Django 1.7.6 works:

<pre><code>MyObject.objects.filter(datetime_attr__startswith=datetime.date(2009,8,22))
</code></pre>

blocks|key|1471811|text|person+=+Profile.objects.get(id=1)

tasks+=+Task.objects.filter(assigned_to=person,+time_stamp__year=person.time_stamp.utcnow().year)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1471812|我的所有模型都有time_stamp，所以我使用person对象来获取当前年份|unstyled|1471813|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>person = Profile.objects.get(id=1)

tasks = Task.objects.filter(assigned_to=person, time_stamp__year=person.time_stamp.utcnow().year)
</code></pre>
all my model do have time_stamp so I used the person objects to obtain the current year

blocks|key|1257259|text|您可以在某些日期范围内进行过滤|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1257260|2016-01-01+00:00:00++<-->++2016-04-01+23:59:59.99999|offset|length|style|CODE|1257261|User.objects.filter(date_joined__gte=datetime.combine(datetime.strptime('2016-+
01-01',+'%25Y-%25d-%25m'),+datetime.min.time()),+
date_joined__lte=datetime.combine(datetime.strptime('2016-04-01',+'%25Y-%25d-%25m'),+
datetime.max.time())).count()|code-block|syntax|javascript|1257262|2016-01-01+00:00:00++<-->++2016-01-14+00:00:00|1257263|User.objects.filter(date_joined__gte='2016-01-01',+date_joined__lte='2016-1-14').count()|1257264|entityMap^0|0|0|1G|0|0|0|1A|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

You can filter between some day ranges
<code>2016-01-01 00:00:00 &lt;--&gt; 2016-04-01 23:59:59.99999</code>
<pre><code>User.objects.filter(date_joined__gte=datetime.combine(datetime.strptime('2016- 
01-01', '%Y-%d-%m'), datetime.min.time()), 
date_joined__lte=datetime.combine(datetime.strptime('2016-04-01', '%Y-%d-%m'), 
datetime.max.time())).count()
</code></pre>
<code>2016-01-01 00:00:00 &lt;--&gt; 2016-01-14 00:00:00</code>
<pre><code>User.objects.filter(date_joined__gte='2016-01-01', date_joined__lte='2016-1-14').count()
</code></pre>

blocks|key|1471922|text|就像这样简单，如果你有一个日期字段，你可以使用datetime.date.today()|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1471923|context['now']+=+Mymodel.objects.filter(date_time_field=datetime.date.today())|code-block|syntax|javascript|1471924|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Just as simple as that if you have a datetimefield your can use datetime.date.today()
<pre><code>context['now'] = Mymodel.objects.filter(date_time_field=datetime.date.today())
</code></pre>

I am trying to filter a <code>DateTimeField</code> comparing with a date. I mean:

<pre><code>MyObject.objects.filter(datetime_attr=datetime.date(2009,8,22))
</code></pre>

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 <code>00:00</code>.

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

数据库

Django

MySQL

我正在尝试过滤与日期进行比较的DateTimeField。我的意思是：MyObject.objects.filter(datetime_attr=datetime.date(2009,8,22))我得到一个空的查询集列表作为答案，因为(我认为)我没有考虑时间，但我想要“任何时间”。在Django中有什么简单的方法可以做到这一点吗？我设置了datetime中的时间，它不是00:00。

问如何在Django中过滤DateTimeField的日期？
EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django中过滤DateTimeField的日期？EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django中过滤DateTimeField的日期？
EN