| From: | Tim Uckun <timuckun(at)gmail(dot)com> |
|---|---|
| To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: Re: Timestamp with vs without time zone. |
| Date: | 2021-09-21 08:45:36 |
| Message-ID: | CAGuHJrPad=kC8y=ecDRz6UaHkhpu8eA62Y=7+BDxmEa6OD6D2g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)Hilbert(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Uckun | 2021-09-21 08:50:44 | Re: Re: Timestamp with vs without time zone. |
| Previous Message | Peter J. Holzer | 2021-09-21 08:44:20 | Re: Re: Timestamp with vs without time zone. |