Re: Postgres and timezones - Mailing list pgsql-general

From Steve Rogerson
Subject Re: Postgres and timezones
Date
Msg-id 569FB85C.2040206@yewtc.demon.co.uk
Whole thread Raw
In response to Re: Postgres and timezones  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
On 20/01/16 15:38, Steve Crawford wrote:
> 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
>

A bit - but what's missing is to know if daylight savings is in effect. So it
could be WET or WEST so we need a date time and an TZ to work it out.


Steve







pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Postgres and timezones
Next
From: Adrian Klaver
Date:
Subject: Re: Syntax error for Function