Re: RFC 9557 / IXDTF

2025-11-16 Thread Tom Lane
[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

Re: RFC 9557 / IXDTF

2025-11-16 Thread David Rowley
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

Re: RFC 9557 / IXDTF

2025-11-16 Thread Adrian Klaver
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

RFC 9557 / IXDTF

2025-11-16 Thread pgmis
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