times.sql

create table times (
  id bigserial not null primary key,
  ts timestamp without time zone not null,
  z text not null
);

insert into times (ts, z) values ('2018-12-05 8:00', 'Europe/Zurich');
insert into times (ts, z) values ('2018-12-05 7:00', 'UTC');
insert into times (ts, z) values ('2018-12-05 7:00', 'Europe/Zurich');

select * from times where ts at time zone z = '2018-12-05 8:00 Europe/Zurich';