如何将Django模型DateTimeField转换为本地时区并使用Q对象进行过滤

Question

如何将db DateTime字段转换为本地时间，并构造用于检索数据集的Q对象？

settings.py

LANGUAGE_CODE = 'en-us'
USER_TIME_ZONE = 'US/Pacific'
TIME_ZONE = 'UTC'
USE_TZ = True

models.py

class Hello(models.Model):

  lucky_day = models.DateTimeField()

一条db格式的记录(UTC格式)

2019-02-03 03:02:45

filter.py

# Client browser is Pacific time without time, date only.
localtime_str = '2019-3-2' 

qset_filter = Q(lucky_day<to Pacific time from UTC>=localtime_str)

Answer 1

如果您确实希望首先将utc日期时间字段转换为本地日期时间，然后根据localdatetime进行过滤，则可以使用django聚合来实现此目的：

YourModel.objects.annotate(new_local_datetime_field=convert_to_local_datetime('lucky_day')).filter(Q(new_local_datetime_field=some_other_datetime))

将utc datetime转换为本地datetime的引用：Convert UTC datetime string to local datetime

引用django注解：https://docs.djangoproject.com/en/2.2/ref/models/querysets/#django.db.models.query.QuerySet.annotate