Postgres 16

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

create table test(tstz timestamptz);
insert into test values ('today') returning tstz;

CREATE TABLE

tstz

2024-02-10 00:00:00+00

INSERT 0 1

create view v_test as 
  select tstz at time zone current_setting('timezone',true) as tstz 
  from test;

select tstz from v_test;

CREATE VIEW

tstz

2024-02-10 00:00:00

SELECT 1

SET TIME ZONE 'Europe/Berlin';
select tstz from v_test;

SET

tstz

2024-02-10 01:00:00

SELECT 1