Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output.

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Paul McGarry <paul(at)paulmcgarry(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output.
Date: 2019-09-24 02:40:12
Message-ID: 87impio1tf.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "Adrian" == Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:

Adrian> This has come up before and the general suggestion has been to
Adrian> have a column for a naive(timestamp w/o tz) timestamp and a
Adrian> column for the timezone.

No, that's usually (not always) backwards, and in any event wouldn't
solve this particular issue.

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2019-09-24 05:06:42 Re: Autovacuum lock conflict
Previous Message Adrian Klaver 2019-09-24 00:58:19 Re: postgres 9.6: insert into select finishes only in pgadmin not psql