BUG #3997: Venezuela TIMEZONE

Started by Aaron Mizrachiabout 18 years ago2 messagesbugs
Jump to latest
#1Aaron Mizrachi
unmanarc@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Aaron Mizrachi (#1)
Re: BUG #3997: Venezuela TIMEZONE

"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