On Mon, 17 Nov 2025 at 08:44, <pgmis@posteo.net> wrote:
> If not, is there some suggestion on how to best store information like
> this?
You could just store the time zone name separately, e.g:
create table ts (ts timestamptz, tz text);
insert into ts values(now(), 'America/Los_Angeles');
select ts at time zone tz from ts;
timezone
----------------------------
2025-11-16 13:18:14.075491
David