From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Converting timestamp to timestamptz without rewriting tables |
Date: | 2017-12-18 08:13:38 |
Message-ID: | p17t7n$8eh$1@blaine.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Dunstan schrieb am 18.12.2017 um 09:08:
> We have generally been using timestamps without timezones in our
> system. As both our app servers and db server were set to UTC it so
> far hasn't been an issue. However, that may not always be the case,
> so we want to tighten things up a bit. We are also needing to do
> things like get the particular date that a timestamp in the db refers
> to, and thus need to be explicit about which timezone everything is
> in.
>
> All of the timestamps in our system represent an instant in time, not
> a clock date/time, so timestamp with time zone is more appropriate.
> All of the data that is currently on disk in timestamp columns was
> inserted in a db session in UTC, and represents that timestamp in
> UTC.
Are you aware of the fact that "timestamp with time zone" does NOT actually store the time zone?
A timestamptz stores everything as UTC and the value is converted to the session time zone upon retrieval.
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Dunstan | 2017-12-18 08:18:00 | Re: Converting timestamp to timestamptz without rewriting tables |
Previous Message | Tom Dunstan | 2017-12-18 08:08:07 | Converting timestamp to timestamptz without rewriting tables |