times.sql

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

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

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