Re: Daylight Saving

2006-02-09 Thread Bill Moseley
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

Re: Daylight Saving

2006-02-09 Thread Rick Measham
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

Re: Daylight Saving

2006-02-09 Thread Dave Rolsky
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

Re: Daylight Saving

2006-02-09 Thread Rick Measham
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

Re: Australia daylight savings extended in 2006

2006-02-09 Thread Rick Measham
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