Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres and timezones - Mailing list pgsql-general

From Steve Crawford
Subject Re: Postgres and timezones
Date
Msg-id CAEfWYyxMnDYduJxjAQSvt4AV9BT+7x_tvf739SVB-f65vyzadg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres and timezones  (Steve Rogerson <steve.pg@yewtc.demon.co.uk>)
Responses Re: Postgres and timezones  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Postgres and timezones  (Steve Rogerson <steve.pg@yewtc.demon.co.uk>)
List pgsql-general
Tree view
Is this of any use?

select * from pg_timezone_names where name = 'Europe/Lisbon';
    name      | abbrev | utc_offset | is_dst
---------------+--------+------------+--------
Europe/Lisbon | WET    | 00:00:00   | f

-Steve

On Wed, Jan 20, 2016 at 7:24 AM, Steve Rogerson <steve.pg@yewtc.demon.co.uk> wrote:
On 20/01/16 13:27, Pavel Stehule wrote:
>
>
>
> Postgres doesn't store original TZ. It does recalculation to local TZ. If you
> need original TZ, you have to store it separetely.
>

I know and that's what I'm trying to deal with. Given I know the origin TZ  -
as in Europe/Lisbon I'm trying to determine the short name so I can store it.

I guess I'll have to use something other than pg to do it.

Steve




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Postgres and timezones
Next
From: Pavel Stehule
Date:
Subject: Re: Postgres and timezones