Re: Confused by timezones - Mailing list pgsql-sql

From Alessio Bragadini
Subject Re: Confused by timezones
Date
Msg-id 3A3E2A64.3A03838@albourne.com
Whole thread Raw
In response to Confused by timezones  (Alessio Bragadini <alessio@albourne.com>)
List pgsql-sql
Tom Lane wrote:

> I'm guessing that's not a legal timezone name on your platform.
> On my box I have to spell it "PST8PDT" ... note that the displayed
> abbreviation is not the same as the name used to set the timezone.

I used PST as an example, but it doesn't work with any other zone,
including GMT (our localtime is EET). I suspect it's a configuration
problem on our Digital machine (with Digital Unix 4.0F): zoneinfos are
under /etc/zoneinfo. 

Do the functions use those files or it's just an OS call? Is configure
involved at all in this area?

Thanks again

-- 
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"    -- The Eighth Networking Truth from RFC 1925


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Best database structure for timely ordered values
Next
From: Bruce Momjian
Date:
Subject: Re: Best database structure for timely ordered values