BUG #3948: date/time functions returning wrong value

From: "Jorge Campins" <jrcampins(at)cantv(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3948: date/time functions returning wrong value
Date: 2008-02-09 22:02:59
Message-ID: 200802092202.m19M2xFs098451@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3948
Logged by: Jorge Campins
Email address: jrcampins(at)cantv(dot)net
PostgreSQL version: 8.1
Operating system: Windows XP
Description: date/time functions returning wrong value
Details:

As you might be aware, recently Venezuela has changed his timezone from GMT
-4 to GMT -4:30. Windows implemented a new timezone for us, "Caracas", to be
used instead of "Caracas/La Paz".

As soon as I changed my computer's timezone to "Caracas", PostgreSQL
date/time functions such as current_timestamp and localtimestamp started to
return a wrong value (I guess they don't recognize the new timezone so they
are returning GMT).

Then I change it to "La Paz", and once again they returned my computer's
time, but of course it has half an hour difference.

I realize this is not really a bug. We will really appreciate your effort to
solve this problem at your earliest convenience.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2008-02-09 23:47:53 Re: BUG #3948: date/time functions returning wrong value
Previous Message Dave Page 2008-02-09 21:02:49 Re: BUG #3947: Unable to Initialize Data Cluster