[email protected] writes:
> does postgres consider some sort of implementation of rfc9557 IXDTF?
> This is new time internet time format which extends timestamps with
> timezone info together with the offset
> - https://datatracker.ietf.org/doc/html/rfc9557
> - https://en.wikipedia.org/wiki/RFC_955
On Mon, 17 Nov 2025 at 08:44, 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
On 11/16/25 11:43, [email protected] wrote:
Hello,
does postgres consider some sort of implementation of rfc9557 IXDTF?
This is new time internet time format which extends timestamps with
timezone info together with the offset
- https://datatracker.ietf.org/doc/html/rfc9557
- https://en.wikiped
Hello,
does postgres consider some sort of implementation of rfc9557 IXDTF?
This is new time internet time format which extends timestamps with
timezone info together with the offset
- https://datatracker.ietf.org/doc/html/rfc9557
- https://en.wikipedia.org/wiki/RFC_9557#Usage
If not, is there