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

From: H Witt <i5d(at)live(dot)com>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names
Date: 2025-04-29 02:40:45
Message-ID: OSBPR01MB29975FFDA1D860B20A8AC85C9B802@OSBPR01MB2997.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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|

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2025-04-29 03:07:35 Re: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names
Previous Message Laurenz Albe 2025-04-26 20:32:38 Re: PGDump question/issue