On Fri, Jan 20, 2006 at 07:26:16AM -0800, Bill Moseley wrote:
I have a zipcode table that lists the city, state, timezone offset
(eg -5) and a flag indicating if the location uses daylight saving
time for U.S. zipcodes. I don't have the Olson name in the table.
How do I set the timezone in
On Fri, Jan 20, 2006 at 07:26:16AM -0800, Bill Moseley wrote:
I have a zipcode table that lists the city, state, timezone offset
(eg -5) and a flag indicating if the location uses daylight saving
time for U.S. zipcodes. I don't have the Olson name in the table.
How do I set the timezone in
On Fri, 10 Feb 2006, Rick Measham wrote:
Does the US ever have more than one TZ per state? As you have the state
It certainly does. Indiana has as least 3, and they vary by county, or
sometimes city, IIRC. There's a couple other states with similar issues.
and so you could do those states
Dave Rolsky wrote:
This could get pretty tricky. You'd really want GIS-type support for
storing the borders of a time zone.
yeah, guess so .. was thinking along the lines of eastern somestate is
Ameria/SomeCity and western somestate is America/AnotherCity. You know
the divide is somewhere
Mike Schilli wrote:
Is DateTime ready for this?
http://support.microsoft.com/?id=909915
http://ftp.support.compaq.com.au/
Sure is. Here's the relevent Olson rules[1]:
RuleAV 19911994- Mar Sun=1 2:00s 0 -
RuleAV 19952005- Mar