Django处理带T、带Z的时间格式
问题:
USE_TZ = False后,django orm 查询时间报错:MySQL backend does not support timezone-aware datetimes when USE_TZ is False.
解决: 查询时间前,做替换
import pytz from django.utils import timezone USE_TZ = False if USE_TZ is True: tzinfo_ = pytz.utc else: tzinfo_ = None start_time_str = '2019-11-01T16:00:00.000Z' end_time_str = '2019-11-02T16:00:00.000Z' # 时间做时区转换 start_time = timezone.datetime.strptime(start_time_str, '%Y-%m-%dT%H:%M:%S.%fZ').replace(tzinfo=tzinfo_) end_time = timezone.datetime.strptime(end_time_str, '%Y-%m-%dT%H:%M:%S.%fZ').replace( tzinfo=tzinfo_) # 查询mysql数据库 query_set = TestModel.objects.filter(create_time__range=(start_time, end_time))
但出来后的时间会定位到16:00,少8小时,具体处理实例:
def get_queryset(self): start = self.request.query_params.get('daterangeStart', None) stop = self.request.query_params.get('daterangeEnd', None) if start and stop: print("---------过滤时间-----------") print(type(start), type(stop)) print(start, stop) tzinfo_ = None # 时间做时区转换 start = timezone.datetime.strptime(start, '%Y-%m-%dT%H:%M:%S.%fZ').replace(tzinfo=tzinfo_) stop = timezone.datetime.strptime(stop, '%Y-%m-%dT%H:%M:%S.%fZ').replace(tzinfo=tzinfo_) # query_set = TestModel.objects.filter(create_time__range=(start_time, end_time)) print(start, stop) start = time.strptime(str(start), '%Y-%m-%d %H:%M:%S') start = time.mktime(start) # start11 = time.strftime("%Y-%m-%d %H:%M:%S",time.localtime(time.time()+28800)) start = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(start + 28800)) stop = time.strptime(str(stop), '%Y-%m-%d %H:%M:%S') stop = time.mktime(stop) stop = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(stop + 28800)) print(start, stop) return DataPointUserActionDetaTextModel.objects.filter(create_datetime__gte=start).filter(create_datetime__lte=stop) return DataPointUserActionDetaTextModel.objects.all()