| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-07-16 05:12:36 | Re: Converting epoch to timestamp |
| Previous Message | Christopher Kings-Lynne | 2004-07-16 04:58:30 | Re: pg_dump - option for just dumping sequences? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kranas | 2004-07-16 07:16:55 | postgresql as windows 2000 service problem |
| Previous Message | Dann Corbit | 2004-07-16 04:23:13 | Re: [HACKERS] Weird new time zone |