Re: Re: Re: Timestamp with vs without time zone. - Mailing list pgsql-general

From Tim Uckun
Subject Re: Re: Re: Timestamp with vs without time zone.
Date
Msg-id CAGuHJrPad=kC8y=ecDRz6UaHkhpu8eA62Y=7+BDxmEa6OD6D2g@mail.gmail.com
Whole thread Raw
In response to Aw: Re: Re: Timestamp with vs without time zone.  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Yes it would record the timestamp and then also record the time zone.
That way all the conversion functions would still work.

That's the way it works in the programming languages I use anyway.

On Tue, Sep 21, 2021 at 8:09 PM Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
>
> > > > It seems like it would be so much more useful if the timestamp with
> > > > time zone type actually stored the time zone in the record.
> > >
> > > Which one ?
> > >
> > One specified by the user.  Many date formats carry either an offset
> > or the time zone information.
>
> What would that TZ mean, exactly, especially in relation to the timestamp itself ?
>
> Would the timestamp be stored as that TZ ?
>
> Karsten



pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Re: Timestamp with vs without time zone.
Next
From: Tim Uckun
Date:
Subject: Re: Re: Timestamp with vs without time zone.