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

From Magnus Hagander
Subject Re: [pgsql-hackers-win32] Weird new time zone
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE34BE85@algol.sollentuna.se
Whole thread Raw
Responses Re: [pgsql-hackers-win32] Weird new time zone  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Point in Time Recovery
Next
From: Tom Lane
Date:
Subject: Re: [pgsql-hackers-win32] Weird new time zone