Home > mailing lists

why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names - Mailing list pgsql-novice

From	H Witt
Subject	why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names
Date	April 29 05:40:45
Msg-id	OSBPR01MB29975FFDA1D860B20A8AC85C9B802@OSBPR01MB2997.jpnprd01.prod.outlook.com Whole thread Raw
Responses	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
List	pgsql-novice

Tree view

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 by date:

From: Laurenz Albe
Date: 26 April, 23:32:38
Subject: Re: PGDump question/issue

From: Tom Lane
Date: 29 April, 06:07:35
Subject: Re: why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names

why at time zone tz_offset not equal tz_name? tz_name has same offset in pg_timezone_names - Mailing list pgsql-novice

Previous

Next