Thread: BUG #3997: Venezuela TIMEZONE

BUG #3997: Venezuela TIMEZONE

From
"Aaron Mizrachi"
Date:
The following bug has been logged online:

Bug reference:      3997
Logged by:          Aaron Mizrachi
Email address:      unmanarc@gmail.com
PostgreSQL version: 8.3.0
Operating system:   Windows
Description:        Venezuela TIMEZONE
Details:

venezuela have a new timezone (-4:30 hrs).

File postgresql-8.3.0/src/timezone/tznames/America.txt:299 does not reflect
that change:

VET    -14400    # Venezuela Time

(-14400 = -4:00)

The right value is: -16200 # -4:30 hrs

---------------------
Check:
http://support.microsoft.com/kb/938977
http://news.bbc.co.uk/2/hi/americas/7134927.stm

Re: BUG #3997: Venezuela TIMEZONE

From
Tom Lane
Date:
"Aaron Mizrachi" <unmanarc@gmail.com> writes:
> venezuela have a new timezone (-4:30 hrs).

Done.  It's a bit unfortunate that they kept the same abbreviation
instead of choosing a new one, but I don't suppose that database
weenies get any say about that ...

            regards, tom lane