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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rob von Nesselrode | 2008-02-11 22:22:42 | BUG #3953: No PostGIS option in installer |
Previous Message | imacat | 2008-02-11 18:27:21 | Re: Vers. 8.3.0: "make check" fails dismally |