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
33037	TruncDay error when using offset timezones on MySQL, SQLite, and Oracle.	Alan	Shafiya Adzhani	"I believe there's a problem using TruncDay with a timezone off-set like 'Etc/GMT+3'. The queryset returns Null values on MySQL.

When using:

{{{
TruncDay('time', tzinfo=timezone('Etc/GMT+03:00'))
}}}


The queryset is translated into:

{{{
CONVERT_TZ(`model`.`time`, 'UTC', '+3')
}}}
Which causes the problem, as this timezone '+3' is not valid.
The timezone is formatted on though _prepare_tzname_delta method on  django/db/backends/mysql/operations.py ."	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	mysql truncdate timezone		Ready for checkin	1	0	0	0	0	0