On 7/6/07, John Trammell <[EMAIL PROTECTED]> wrote:
> -----Original Message----- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 10:51 AM > To: David T. Ashley > Cc: mysql@lists.mysql.com > Subject: Re: zipcode to timezone > > i don't think there is any state got 2 timezones, i could be wrong. Yeah, you are. http://worldatlas.com/webimage/countrys/namerica/usstates/timezone.htm
One other thought comes to mind. Is there a guarantee that a timezone can't split a zipcode? In other words, is the mapping from zipcode->timezone guaranteed to exist in all cases? I remember a friend in Tennessee who would take her children to school (10 miles away) and the school was in a different timezone than her home, so it got very confusing what time the kids had to be up and to bed and all that. In rural areas where the zipcodes can be rather large, I'm just wondering if there is any guarantee that a zipcode can't span two timzones.
