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|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|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|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|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|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|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|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|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|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|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|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|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>

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>

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中有什么简单的方法可以做...

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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