Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

  • From: Magnus Hagander <magnus(at)hagander(dot)net>
  • To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: Jorge Campins <jrcampins(at)cantv(dot)net>, pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: BUG #3948: date/time functions returning wrong value
  • Date: Sun, 10 Feb 2008 10:37:48 +0100
  • Message-id: <47AEC5EC(dot)7090202(at)hagander(dot)net>
Tom Lane wrote:

Magnus Hagander <magnus(at)hagander(dot)net> writes:
Try setting your timezone in postgresql.conf - that should override whatever Windows has for you. 

Unless his "8.1" is really 8.1.something-pretty-darn-recent, it's
not going to know about the latest Venezuela DST law change anyway.


Yes, good point.
Or really, since 8.1 is unsupported, to 8.2.most-recent-available if possible. 



This does suggest that we'll need to revisit the win32_tzmap[] list
every so often?
Seems so. It's the first time I've heard of a timezone being *added* and not just changed, but obviously it does happen :-( 

//Magnus
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group