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
33279	Time zones with minus in names are incorrectly converted.	yakimka	Can Sarıgöl	"Maybe I do something wrong, but I ran into a problem:

{{{
In [1]: import zoneinfo

In [2]: import datetime

In [3]: with timezone.override(zoneinfo.ZoneInfo('Asia/Ust-Nera')):
   ...:     SomeModel.objects.filter(date__date=datetime.datetime.now().date()).only('id').first()
   ...: 
SELECT ""some_model"".""id""
  FROM ""some_model""
 WHERE (""some_model"".""date"" AT TIME ZONE 'Asia/Ust+Nera')::date = '2021-11-10'::date
 ORDER BY ""some_model"".""id"" ASC
 LIMIT 1

Execution time: 0.003478s [Database: default]
---------------------------------------------------------------------------
InvalidParameterValue                     Traceback (most recent call last)
/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py in _execute(self, sql, params, *ignored_wrapper_args)
     83             else:
---> 84                 return self.cursor.execute(sql, params)
     85 

InvalidParameterValue: time zone ""Asia/Ust+Nera"" not recognized

}}}

Timezone ""Asia/Ust-Nera"" supported by psql:


{{{
SELECT name FROM pg_timezone_names where name = 'Asia/Ust-Nera';
}}}


Reproduced on Postgresql 11 and 12 "	Bug	closed	Database layer (models, ORM)	3.2	Normal	fixed		Can Sarıgöl Carlton Gibson	Ready for checkin	1	0	0	0	0	0