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: (view raw, whole thread or download thread mbox)
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

			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-2017 The PostgreSQL Global Development Group