Re: [pgsql-hackers-win32] Weird new time zone - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [pgsql-hackers-win32] Weird new time zone
Date
Msg-id 15961.1089954199@sss.pgh.pa.us
Whole thread Raw
In response to Re: [pgsql-hackers-win32] Weird new time zone  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
"Dann Corbit" <DCorbit@connx.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

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: pg_dump - option for just dumping sequences?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Converting epoch to timestamp