Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. - Mailing list pgsql-general

From Andrew Gierth
Subject Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output.
Date
Msg-id 87impio1tf.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: How to get timezone offset in timestamp with time zone AT TIMEZONE output.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to get timezone offset in timestamp with time zone AT TIMEZONE output.
List pgsql-general
Tree view 
>>>>> "Adrian" == Adrian Klaver <adrian.klaver@aklaver.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)

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
Next
From: Laurenz Albe
Date:
Subject: Re: Autovacuum lock conflict