Python django 在日期范围内按日期时间过滤

Question

提问by user2139745

I have a model with field "created_at", and I have a list of dates. So, I want to get all the models that are created in the date range. How ?

我有一个带有“created_at”字段的模型，我有一个日期列表。所以，我想获取在日期范围内创建的所有模型。如何？

I know that we can compare datetime and date easily using:

我知道我们可以使用以下方法轻松比较日期时间和日期：

queryset.filter(created_at__startswith=date)

But, I have a range of dates, so how ?
Let me know for more information.

但是，我有一个日期范围，那么如何呢？
让我知道更多信息。

Answer 1

You can use __gte(greater than or equal) and __lte(less than or equal). For example:

您可以使用__gte（大于或等于）和__lte（小于或等于）。例如：

queryset.filter(created_at__gte=datetime.date.today())

Answer 2

You can use rangee.g.

您可以使用范围例如

first_date = datetime.date(2005, 1, 1)
last_date = datetime.date(2005, 3, 31)
queryset.filter(created_at__range=(first_date, last_date))

Answer 3

You can use rangelookup. Just find the lowest and greater date and then apply it as:

您可以使用范围查找。只需找到最低和更大的日期，然后将其应用为：

queryset.filter(created_at__range=(start_date, end_date))

Answer 4

Answer 5

You can combine dateand rangefield lookups:

您可以结合日期和范围字段查找：

queryset.filter(created_at__date__range=(start_date, end_date))