Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT '20211203'::timestamp
     , '20211203'::timestamptz
     , '20211203'::timestamp AT TIME ZONE 'Europe/Vienna';  -- try with *your* time zone


timestamp
timestamptz
timezone


2021-12-03 00:00:00
2021-12-03 00:00:00+00
2021-12-02 23:00:00+00


SELECT '20211203'::timestamp AT TIME ZONE 'Europe/Vienna' AS always_right1
     , '20211203'::timestamp AT TIME ZONE 'CET' AS winter_right
     , '20210603'::timestamp AT TIME ZONE 'CET' AS winter_fail
     , '20210603'::timestamp AT TIME ZONE 'Europe/Vienna' AS always_right2
     , '20210603'::timestamp AT TIME ZONE 'CET' AS summer_right
     , '20211203'::timestamp AT TIME ZONE 'CET' AS summer_fail;


always_right1
winter_right
winter_fail
always_right2
summer_right
summer_fail


2021-12-02 23:00:00+00
2021-12-02 23:00:00+00
2021-06-03 00:00:00+01
2021-06-02 23:00:00+01
2021-06-03 00:00:00+01
2021-12-02 23:00:00+00


SHOW timezone;


TimeZone


GB