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: rob stone <floriparob(at)gmail(dot)com>
Cc: Paul McGarry <paul(at)paulmcgarry(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(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-25 03:01:39
Message-ID: 871rw5nkqx.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "rob" == rob stone <floriparob(at)gmail(dot)com> writes:

rob> You can EXTRACT timezone, timezone_hour and timezone_minute from a
rob> timestamp. Using 'timezone' returns a value representing seconds
rob> from UTC.

Yes, but this always outputs a value representing the server timezone;
there's no way (other than the same function set_config trick I gave
above) to make it return a value that represents a different timezone
per row.

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-09-25 04:54:08 Re: Mapping view columns to their source columns
Previous Message rob stone 2019-09-25 02:56:38 Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output.