I think Indiana has two time zones. I think there are also some states or portions thereof that don't observe daylight saving time.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 11:51 AM > To: David T. Ashley > Cc: mysql@lists.mysql.com > Subject: Re: zipcode to timezone > > On Fri, 6 Jul 2007, David T. Ashley wrote: > > > On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote: > >> > >> we have warehouses all over U.S. and i just wonder what is > the best way to > >> find out their timezone base on zipcode. Should i buy a > database or is > >> there any function in mysql or php to get timezone base on > a zipcode? > > > > > > I looked at the zipcode databases ... not as expensive as I > would have > > thought. It might be worth it just to spend the $100 or so. > > > > However, ... > > > > My understanding is that U.S. zipcodes have their first two > digits based on > > state, i.e. "48" is Michigan. > > > > Since most of the time zone boundaries seem to fall on > state boundaries, a > > simple mapping from the first two digits to the time zone > might get you most > > of the way there. > > > > > http://images.google.com/imgres?imgurl=http://worldatlas.com/w ebimage/countrys/namerica/usstates/timezone.gif&imgrefurl=http://worldatlas. com/webimage/countrys/namerica/usstat> es/timezone.htm&h=307&w=427&sz=23&tbnid=pXERv6TKqAu7DM:&tbnh=9 > 1&tbnw=126&prev=/images%3Fq%3Du.s.%2Btime%2Bzone%2Bmap%26um%3D > 1&start=2&sa=X&oi=images&ct=image&cd=2 > > > > However, for those states that are split, I don't know an > easy way ... but > > there shouldn't be very many of those. > > > > Dave. > > > > i don't think there is any state got 2 timezones, i could be > wrong. but > if that the case, state -> timezone is working for me. now, > how do i look > up for timezone if i got state? i don't mind buying the > database, but i > just don't want to replace the database if something change > down the road. > > thanks > T. Hiep > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
