Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table my_timestamptz (tstz timestamptz);

set timezone='PST8PDT';
insert into my_timestamptz
select to_timestamp('Thu, 28 Dec 2023 22:00:00.000000000 PST -08:00, 0.0',
                    'Dy, DD Mon YYYY HH24:MI:SS.US AAA TZH:TZM, AAA')
returning *;

CREATE TABLE

SET

tstz

2023-12-28 22:00:00-08

INSERT 0 1

set timezone='PST8PDT';
select to_char(tstz,
               'Dy, DD Mon YYYY HH24:MI:SS.US TZ TZH:TZM, 0.0') 
from my_timestamptz;

SET

to_char

Thu, 28 Dec 2023 22:00:00.000000 PST -08:00, 0.0

SELECT 1

set timezone='PST8PDT';
select to_char(date 'today'+tstz::timetz,
               'Dy, DD Mon YYYY HH24:MI:SS.US TZ TZH:TZM, 0.0') 
from my_timestamptz;

SET

to_char

Thu, 01 Feb 2024 22:00:00.000000 PST -08:00, 0.0

SELECT 1