﻿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
33664	Timezones with hyphens in name fail in Extract() functions.	Doug Franklin	nobody	"
{{{
local_tz = pytz.timezone(""""Asia/Ust-Nera"")
models = Model.objects.annotate(
    created_at_month=ExtractMonth('created_at', tzinfo=local_tz)
)
}}}

When evaluating the queryset it fails with:


{{{
DataError: time zone ""Asia/Ust+Nera"" not recognized
}}}

The ""+"" in ""Asia/Ust+Nera"" is suspicious.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;
}}}
{{{
```
Asia/Ust-Nera                    | +10    | 10:00:00   | f
...
America/Port-au-Prince           | EDT    | -04:00:00  | t
```
}}}

"	Bug	closed	Database layer (models, ORM)	3.2	Normal	duplicate	timezone extract hyphen		Unreviewed	0	0	0	0	0	0
