id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29726	Setting the Shanghai time zone causes a query error	AberSheeran	nobody	"I have a little website. It's settings.py like this

{{{
LANGUAGE_CODE = 'en-us'

TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

USE_TZ = True
}}}

And then, I had saved some data in SQLite3. But get a error


{{{
>>> for each in Message.objects.all():
...     print(each.create_time.year, each.create_time.month)
... 
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
2018 8
>>> for each in Message.objects.filter(create_time__year=""2018"", create_time__month=""09""):
...     print(each.create_time.year, each.create_time.month)
... 
2018 8
2018 8
2018 8
>>> 
}}}

These three messages were sent in the last eight hours of August 31, 2018 UTC. The result of querying through .all() is UTC time. But the result of querying through .filter() is Asia/Shanghai time. This brings me some trouble...


"	Bug	closed	Database layer (models, ORM)	2.1	Normal	invalid			Unreviewed	0	0	0	0	0	0