Shulou(Shulou.com)06/01 Report--

Editor to share with you how to deal with the time period query in django, I believe most people do not know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

Note: the field type of publish_time here should be date or datetime, otherwise it is beyond the scope of this article.

Now = datetime.datetime.now ()

Start = datetime.datetime (2017 jade 1)

1. Greater than a certain time (gt)

Aticle.objects. Filter (publish_time__gt=now)

2. Greater than or equal to a certain time (gte)

Aticle.objects. Filter (publish_time__gte=now)

3. Less than a certain time (lt)

Aticle.objects. Filter (publish_time__lt=now)

4. Less than or equal to a certain time (lte)

Aticle.objects. Filter (publish_time__lte=now)

5. Query period (range)

Aticle.objects .filter (publish_time__range= (start,now))

6. Query a certain year (year)

Aticle.objects. Filter (publish_time__year=now.year)

7. Query a month (month)

Aticle.objects. Filter (publish_time__month=now.month)

8. Query one day (day)

Aticle.objects. Filter (publish_time__day=now.day)

9. Inquire what day of the week (week_day)

Aticle.objects. Filter (publish_time__week_day=1)

The above is all the contents of this article entitled "how to handle time period queries in django". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.