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
33663	Timezones with hyphens in name fail in Extract() functions.	Doug Franklin	nobody	"
{{{
local_tz = pytz.timezone(""""Asia/Ust-Nera"")
Model.objects.annotate(
    created_at_month=ExtractMonth('created_at', tzinfo=local_tz)
)
}}}

Fails with:


{{{
DataError: time zone ""Asia/Ust+Nera"" not recognized
}}}

I have confirmed this fails with other timezones with hyphens, such as ""America/Port-au-Prince"".

I have also confirmed my postgresql DB supports these timezones:

{{{
SELECT
    name,
    abbrev,
    utc_offset,
    is_dst
FROM pg_timezone_names
WHERE name !~ 'posix'
ORDER BY name asc;
}}}

"	Bug	closed	Database layer (models, ORM)	4.0	Normal	duplicate			Unreviewed	0	0	0	0	0	0