why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names

Поиск

Список

Период

Сортировка

От	H Witt
Тема	why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names
Дата	29 апреля 05:40:45
Msg-id	OSBPR01MB29975FFDA1D860B20A8AC85C9B802@OSBPR01MB2997.jpnprd01.prod.outlook.com обсуждение исходный текст
Ответы	Re: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names Re: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names Re: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names
Список	pgsql-novice

select

'2025-02-03 15:04:05'::timestamptz at time zone '+08:00',

'2025-02-03 15:04:05'::timestamptz at time zone 'Asia/Shanghai'

display

|2025-02-02 23:04:05.000|2025-02-03 15:04:05.000|

В списке pgsql-novice по дате отправления: