From: H Witt <i5d@live.com>
To: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Subject: why at time zone tz_offset not equal tz_name?  tz_name has same
 offset in pg_timezone_names
Thread-Topic: why at time zone tz_offset not equal tz_name?  tz_name has same
 offset in pg_timezone_names
Thread-Index: AQHbt+g2neMFZVGh20moEyOG9cP6I7O58DwQ
Date: Tue, 29 Apr 2025 02:40:45 +0000
Message-ID: 
 <OSBPR01MB29975FFDA1D860B20A8AC85C9B802@OSBPR01MB2997.jpnprd01.prod.outlook.com>
References: 
 <OSBPR01MB299716C895A69A6DFCF3357C9B812@OSBPR01MB2997.jpnprd01.prod.outlook.com>
In-Reply-To: 
 <OSBPR01MB299716C895A69A6DFCF3357C9B812@OSBPR01MB2997.jpnprd01.prod.outlook.com>
Accept-Language: zh-CN, en-US
Content-Language: zh-CN
msip_labels: 
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: OSBPR01MB2997:EE_|TY4PR01MB13446:EE_
x-ms-office365-filtering-correlation-id: 1e4719c8-72f6-4150-5ea8-08dd86c73e49
x-microsoft-antispam: 
 BCL:0;ARA:14566002|19110799003|461199028|15030799003|7092599003|15080799006|8062599003|8060799006|102099032|3412199025|440099028|3430499032;
x-microsoft-antispam-message-info: 
 =?gb2312?B?S0NNMEYzWExRclFCTm92TEpUV2tCQ0ZkN2NQclZ5NlUzb0JCWXZCbkVXTTc0?=
 =?gb2312?B?N09zQ0lka3M0ZXg0OExjMlF5djRqMlVoRm5EWkxyWjlvcFNKWFRzeGZFd3Q1?=
 =?gb2312?B?OWlWTkRIOTR3MmFzOTVKSjc5U0NDUUd1L21NaERpU1k4RFIvS1Jnd0NZb1dz?=
 =?gb2312?B?M3E3SUl3YzliNHFJb3V1RlVyWUM2VUFpQnBsMjlYeU5Gd1F3WUVIRVdaemFN?=
 =?gb2312?B?Tys3WHAxUmdGTitkeEQ0SkgweW5DNkhvN0lnRHVuUUJ0aVE1K3BlbmZaY2pp?=
 =?gb2312?B?cWZmUXNRekVSTm1heTRlQ0krc0hSa0NVeUpWRXpnNjUrd1llUURYeGJLY2E1?=
 =?gb2312?B?MGVxdVFGMHFFTFh4VE5xQkVpbDFleG91dkYrU3l5bVJSWFoyS1orZlF2LzIw?=
 =?gb2312?B?UDZVNW05Y0lITHBtL2lPN3I3UGNrZng3L0dJK1crdkZIem9PSlBoQXJQMld3?=
 =?gb2312?B?a0FMWkxWell1bjQxRXpDUjFNVjUrSFlzTVkrUVdON2x3emJIMkpXaW5iWTlI?=
 =?gb2312?B?NGRNaUw2Z1pPanlhcERwYmt1MTc0ZGpIem9xcXBKZWNnTzRKR0RoZjErWGhl?=
 =?gb2312?B?SG5GOW9VbGRuUUxjUTJGUG41cGtsNXRVekxWRU5xejNNK3ZvYXROeEVCdWdt?=
 =?gb2312?B?aUZWL1lBTWhQRnlVUDZHU3YrdGF1amJuQ21QMTkzRkZOOUhtbzN1MDdQbHkx?=
 =?gb2312?B?YWFPZUFEU1hHZ3V5MGhYS212U3YwQm9sdXNvSytWUEY0N2Rudll2a2pDZlYr?=
 =?gb2312?B?QUtOZ3ZPVjU1TEpvVFV4aENscnlpTU5FKzJld3dkakVyRFJUdDNkYWJWMDQ5?=
 =?gb2312?B?L0N6MWdiRXpwT2haUWtyaGs3cWNkcTRPU0VqOW4yOE1IVVNvcWxrQUozamMv?=
 =?gb2312?B?aTZHSnBCVDAyYzdoaFlhWTFhMUVKT0xZcXRZKzdDK1ZPeUhleXFRT01KQjB3?=
 =?gb2312?B?ZEplYlFyYTlVV1RFblU2aTVkSlNkZDNtT1pwRmFOQzFGbmtITVVVZWZQMklz?=
 =?gb2312?B?NHV0TWs5K3cwRUxlTG5xcGdXUXlYaTlwRGNGQm93UDlpd2VlaU5EVVV2QlV1?=
 =?gb2312?B?QkpHVDJnQ2pmOVhFcVVDYmY0MGtJNEJucGswMVp5WURGMTVhS1hDRzFPRU9E?=
 =?gb2312?B?a0NCS3lyU0h4ZHJreldyVmxiTXo5VnRkZDVHeWJkNXQ3c3c0R1ZQQVJpS2Ru?=
 =?gb2312?B?Uk52bUhPWGRTYld2c3kwNmZTKzNBVXhUb2ZOMUp6UFhuUVlIVHE1N3JleWx2?=
 =?gb2312?B?OEVnVmpuZWNUYUpockZnQWIyTjNkMk1lMkJDcmZEUXZqYWlaZHU2VndEMTVt?=
 =?gb2312?B?NFMzNnFMa25BTTRGdjhWSlE2UjVnMUlGVDBLR0VEWEpvK0w3cVRWdjdHV2E0?=
 =?gb2312?B?ZTdFWUViS3l3MDRiSWsyQVIyK1BwWHUwbzhZTXNzSW5ncWczdFFQc21aSlpD?=
 =?gb2312?B?ekNQREg5dnI4SjhhaTZTeHdYZ0pZRjZCWFlHRTNwa1Q4YVZyeWVvbzNWUHNk?=
 =?gb2312?B?SWU2MWtsbStnc01meXFYWWV6Q09YNE9tU1FNMUNCU2tjSVpJblpITHNoUEFV?=
 =?gb2312?B?aFQwQT09?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?gb2312?B?azRPUUVBYzkwK21lWGVXU3Fqcmo5T20vNzdlREdhMlRCMFZCOHJzSjAzV0Y5?=
 =?gb2312?B?eXVYREpZang2SzdqNUFUU3YwcjNtS0ZrV3RyKzhoRXQ0cDFlZWdnV3JoODBV?=
 =?gb2312?B?V0F3YXA4M3dPaENsQ3h5WUlCZExrT1UyeXd4cUtCUXVmWE9MU0dYNTA2OTht?=
 =?gb2312?B?WjdpeW0wcUVKYW9Xc0syaGpKekpLQzBhRkIyaVJMcVBSdHQwbVN1U2RZVDhr?=
 =?gb2312?B?cVB5K1A1a1BTckp0SnJSMlFpRndYQW5wMG95NXRkU0o4VnAwRnl3ZllHVHhQ?=
 =?gb2312?B?enlJVG02cGNKTkpsMVdNcWZjN0ZNdFpKNjA2ZmZqSktqRUR3L0Q5TUhZeVRh?=
 =?gb2312?B?Tmh6NzBYWkpxbk1DdEVHa29mZ2ZWZDliU3NKbDdvRTY0UFREamUzRUY3bUd5?=
 =?gb2312?B?OGpKUmJaT3A0K0hodTk0VjRoUFlGY2pMUERJbldFQjQrOXBSdDB1RzVCeCtS?=
 =?gb2312?B?UG1FR1phd04yUjlvV2c3cTVxcjZwUm1KN0RYZkVzMldZWDkyamE4alk4Uzl2?=
 =?gb2312?B?TFZSUmRkQUZqN0dxZGxET0Z4ZVRQY21kdUxwMjZ3UEFYeWhSZXZuSHR0L3Q4?=
 =?gb2312?B?aFZHVnZsMlBSNXp0eWFxYk4ycW5ibUhyTCtEOHNxVFRXaTB0WWYvNzUzbm1X?=
 =?gb2312?B?Mlh4ZFpYdHN6bFo1ZytRMUpNL2IzWk1lSWdWS1dPVFRhRU1NZWZXQUNCMHRh?=
 =?gb2312?B?M3IzZ0Z1alB6MHZvN2J6N0pWNlp5TVpOeGJxM3dwQnN3RmRXbUZFQ0tDZ3ho?=
 =?gb2312?B?bHE5QnVoa1dmajFCdGdDNXQzQUpFYXYzS3dmd2tDK294ZUQ2aGF4ay82cmVj?=
 =?gb2312?B?dGVPcCtGWkxQb3VCM3pEMEloRlRCSVJhSW5wYWhnb0lJZlA3MmhFNnNDVVha?=
 =?gb2312?B?Slp1aXpBMk5CVStVdWJka0UyU04xc2RMdmZoSFpxbU1tc0xsSEdoM0hlVU0r?=
 =?gb2312?B?bjQwRU9WajZUYkR3NjAreklhU1BZTC81WFFRbVBZRXdUVnpQSjRLcm9pMjR2?=
 =?gb2312?B?YkxBdFRwS1JPSHhyaDN0TkoydjhjZmpkUzBxNWF2bTJza1ZBZG9PUjN2Tmlj?=
 =?gb2312?B?M0RDMDVLQlVRNG8xeEVGVEl1Q1FJYnFhVmdZZEh1VzMwVUlHNHNlK1ZZTC9O?=
 =?gb2312?B?ak5sN0RkQjRlUkpZN1lHb2FVM0x0RTR6SUZYaTNGN3dvbTUvclRGbC9wUGtU?=
 =?gb2312?B?Z2ZBTWxGcll5aktNSE5ROWxXNXlBV2h3Y0VabUNkUlk3QmR1RDE5Wm1XKzdQ?=
 =?gb2312?B?eE1oUFFDUWZ0T0d6Zk51U0dDWG8rcjQzYmF3czRQcElNMzFpUnJJYmI1RXhT?=
 =?gb2312?B?UTg2Y0FSZ1dFcVhNbEQyN3gvNlVXODc1LzNaVEEzU2xGR01tUU9CZzhmbE1E?=
 =?gb2312?B?cWRHSWZWSlNLdnB6TzNBcW1tTnkrb3dBNmhBQnlYVGc3WXlSV1ozeDRSZm50?=
 =?gb2312?B?V3BPcTlFOWgxdTYra1JqQmZzL0JrTElaL2dZQm5TR29KM29EblpJUjlldGI5?=
 =?gb2312?B?c2lCd1hYUm1IbUs4SDk1SGVCUHd4NFh5OExLUEhMVW1VQmg3VGJSOHVMdXJp?=
 =?gb2312?B?UUMzYm45UG1qaWFCWUFRM3kremdFMHBvSHdKNjV5ekFWWHEwanp0Z1ZBK2RK?=
 =?gb2312?B?UkpUUnlZYjM3cFA1Q0NVM3EySlZBQUE9PQ==?=
Content-Type: multipart/alternative;
	boundary="_000_OSBPR01MB29975FFDA1D860B20A8AC85C9B802OSBPR01MB2997jpnp_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-15995.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: OSBPR01MB2997.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 1e4719c8-72f6-4150-5ea8-08dd86c73e49
X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Apr 2025 02:40:45.7796
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY4PR01MB13446
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/OSBPR01MB29975FFDA1D860B20A8AC85C9B802%40OSBPR01MB2997.jpnprd01.prod.outlook.com>
Precedence: bulk

--_000_OSBPR01MB29975FFDA1D860B20A8AC85C9B802OSBPR01MB2997jpnp_
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: base64

c2VsZWN0DQonMjAyNS0wMi0wMyAxNTowNDowNSc6OnRpbWVzdGFtcHR6IGF0IHRpbWUgem9uZSAn
KzA4OjAwJywNCicyMDI1LTAyLTAzIDE1OjA0OjA1Jzo6dGltZXN0YW1wdHogYXQgdGltZSB6b25l
ICdBc2lhL1NoYW5naGFpJw0KDQpkaXNwbGF5DQp8MjAyNS0wMi0wMiAyMzowNDowNS4wMDB8MjAy
NS0wMi0wMyAxNTowNDowNS4wMDB8DQo=

--_000_OSBPR01MB29975FFDA1D860B20A8AC85C9B802OSBPR01MB2997jpnp_
Content-Type: text/html; charset="gb2312"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dgb2312">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div dir=3D"ltr" id=3D"divRplyFwdMsg"></div>
<div style=3D"padding-left: 2px;">
<div style=3D"direction: ltr; margin: 0px; font-family: Aptos, Aptos_Embedd=
edFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12p=
t; color: rgb(0, 0, 0);">
select&nbsp;</div>
<div style=3D"direction: ltr; margin: 0px; font-family: Aptos, Aptos_Embedd=
edFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12p=
t; color: rgb(0, 0, 0);">
'2025-02-03 15:04:05'::<b>timestamptz</b> <i>at</i> <b>time</b> <b>zone</b>=
&nbsp;'+08:00',</div>
<div style=3D"direction: ltr; margin: 0px; font-family: Aptos, Aptos_Embedd=
edFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12p=
t; color: rgb(0, 0, 0);">
'2025-02-03 15:04:05'::<b>timestamptz</b> <i>at</i> <b>time</b> <b>zone</b>=
&nbsp;'Asia/Shanghai'</div>
</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb=
(0, 0, 0);">
<br>
</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb=
(0, 0, 0);">
display</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
|2025-02-02 23:04:05.000|2025-02-03 15:04:05.000|</div>
</body>
</html>

--_000_OSBPR01MB29975FFDA1D860B20A8AC85C9B802OSBPR01MB2997jpnp_--