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

[Magnus Hagander <magnus(at)hagander(dot)net>]

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