Skip site navigation (1) Skip section navigation (2)

Re: BUG #3948: date/time functions returning wrong value

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Jorge Campins <jrcampins(at)cantv(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3948: date/time functions returning wrong value
Date: 2008-02-11 19:55:27
Message-ID: 47B0A82F.1020603@hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Jorge Campins wrote:
> Dear All,
> 
> I installed 8.2.6.2 and solved my problem. I set Windows time zone to 
> "Caracas" and PostgreSQL "America/Caracas" and now they both give me the 
> right time.
> 
> WARNING: not only people in Venezuela but also people in Bolivia is 
> affected by this problem. As you might recall, Windows used to have a 
> single time zone for both countries, namely "Caracas/La Paz". If now you 
> set Windows time zone to "La Paz", PostgreSQL 8.2.6.2 will use 
> "America/Caracas" unless you specify something else in postgresql.conf. 
> In this case, Windows has Bolivia's time and PostgreSQL has Venezuela's 
> time. So people in Bolivia should also specify timezone in postgresql.conf.

Yeah, I've got an update that has some more timezones around here 
available coming up, I think that's going to help it. But always - the 
pg database of timezones is a lot more extensive than the Windows one, 
so it's always a good idea to check it out.


//Magnus

In response to

pgsql-bugs by date

Next:From: Rob von NesselrodeDate: 2008-02-11 22:22:42
Subject: BUG #3953: No PostGIS option in installer
Previous:From: imacatDate: 2008-02-11 18:27:21
Subject: Re: Vers. 8.3.0: "make check" fails dismally

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group