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

Re: [HACKERS] Weird new time zone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
Cc: "Oliver Jowett" <oliver(at)opencloud(dot)com>,"Magnus Hagander" <mha(at)sollentuna(dot)net>,"Hackers" <pgsql-hackers(at)postgresql(dot)org>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: [HACKERS] Weird new time zone
Date: 2004-07-16 05:03:19
Message-ID: 15961.1089954199@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
"Dann Corbit" <DCorbit(at)connx(dot)com> writes:
> All translations between UTC time and local time are based on the
> following formula:

> UTC = local time + bias

Surely not.  Or has Windows not heard of daylight-savings time?
Or perhaps they have, but are not aware that the DST laws have
changed often in the past?

Over-simplistic answers are not what we need here.  The data structure
you quote cannot even tell what DST transition dates Windows thinks
are in effect this year, let alone what it thinks the dates were in past
years.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2004-07-16 05:12:36
Subject: Re: Converting epoch to timestamp
Previous:From: Christopher Kings-LynneDate: 2004-07-16 04:58:30
Subject: Re: pg_dump - option for just dumping sequences?

pgsql-hackers-win32 by date

Next:From: kranasDate: 2004-07-16 07:16:55
Subject: postgresql as windows 2000 service problem
Previous:From: Dann CorbitDate: 2004-07-16 04:23:13
Subject: Re: [HACKERS] Weird new time zone

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group