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

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [pgsql-hackers-win32] Weird new time zone
Date: 2004-07-16 11:02:17
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE34BE85@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > 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.
>
> Yes, there are other calls for that, obviously. I sent to
> Mr. Momjian a complete implementation of time zone stuff that
> uses Windows calls.
> It's also accurate to a fraction of a nanosecond millions of
> years into the past and the future.

You wouldn't happen to know if Windows internally has knowledge of the
many different DST rules in force at different years? See the other mail
about how it apparantly deals with Swedish DST - if that's common or a
single case?
If the OS doesn't have that knowledge, we can give up trying to get it
to tell us about it :-)

> The call that I showed returns the NAME OF THE TIME ZONE and
> also what it is called when you are in Daylight savings time.
> I thought the issue under question was to find out what the
> time zone was.

Nope, we already had that. The issue is that the names are not the same
as the one used in zic/unix, so there is nothing to match on.

//Magnus

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-07-16 13:23:01 Re: [pgsql-hackers-win32] Weird new time zone
Previous Message Zeugswetter Andreas SB SD 2004-07-16 10:16:44 Re: Point in Time Recovery