473,486 Members | 1,953 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Seeking table matching time zone specifications with 5-digit ZIP codes for continental US and territories

MLH
I would like to be able to look up any 5-digit ZIP in a table
that would show the correct time zone for the area. For
example, I would like to look up 91915 in the table and
see something that indicates Pacific Time Zone or 27615\
would be found as Eastern Time Zone.

I guess I want Eastern Time Zone, Central Time Zone,
Mountain Time Zone, Pacific Time Zone, Atlantic Time
Zone along with Palau, Hawaii, Guam and all the others
for the various territories.

I have a 43,000+ zip code table, but no timezone data.
'ppreciate your help!
Nov 13 '05 #1
2 6274
Available on the web for $40.
http://www.zipinfo.com/products/z5p/z5p.htm

MLH <CR**@NorthState.net> wrote in message news:<jc********************************@4ax.com>. ..
I would like to be able to look up any 5-digit ZIP in a table
that would show the correct time zone for the area. For
example, I would like to look up 91915 in the table and
see something that indicates Pacific Time Zone or 27615\
would be found as Eastern Time Zone.

I guess I want Eastern Time Zone, Central Time Zone,
Mountain Time Zone, Pacific Time Zone, Atlantic Time
Zone along with Palau, Hawaii, Guam and all the others
for the various territories.

I have a 43,000+ zip code table, but no timezone data.
'ppreciate your help!

Nov 13 '05 #2
We get the info from the following Web Site.

http://www.zipcodeworld.com/zipcodepremium.htm

Cy******@yahoo.com (Dave O) wrote in message news:<74**************************@posting.google. com>...
Available on the web for $40.
http://www.zipinfo.com/products/z5p/z5p.htm

MLH <CR**@NorthState.net> wrote in message news:<jc********************************@4ax.com>. ..
I would like to be able to look up any 5-digit ZIP in a table
that would show the correct time zone for the area. For
example, I would like to look up 91915 in the table and
see something that indicates Pacific Time Zone or 27615\
would be found as Eastern Time Zone.

I guess I want Eastern Time Zone, Central Time Zone,
Mountain Time Zone, Pacific Time Zone, Atlantic Time
Zone along with Palau, Hawaii, Guam and all the others
for the various territories.

I have a 43,000+ zip code table, but no timezone data.
'ppreciate your help!

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
3222
by: Együd Csaba | last post by:
Hi All, how can I improve the query performance in the following situation: I have a big (4.5+ million rows) table. One query takes approx. 9 sec to finish resulting ~10000 rows. But if I run...
3
35029
by: Jon Davis | last post by:
The date string: "Thu, 17 Jul 2003 12:35:18 PST" The problem: // this fails on PST DateTime myDate = DateTime.Parse("Thu, 17 Jul 2003 12:35:18 PST"); Help? Jon
1
2305
by: Clodoaldo Pinto Neto | last post by:
Hi all, I want to have the time zone string (like 'BRT') displayed after a date-time. The date column is of the type timestamp with time zone. But the time zone is not displayed. It works for...
14
2620
by: Cesar Ronchese | last post by:
Hello! I've built a program that show some dates to users. I got a problem when users have different configured time zone machines, where: - One machine that determined time zone the date...
3
2723
by: Satish Itty | last post by:
Hi all, I have a big problem in my hands and not sure how I can fix this. Any suggestions would be greatly appreciated. I have a .NET 3 tier app developed in VS2003 and .NET 1.1. the client is a...
0
1328
by: waggledance | last post by:
I was wondering if anyone here might be able to offer me some advice for someone who can only use Macromedia Dreamweaver MX. I am (clearly!) a web design novice so apologies in advance if this is a...
7
5497
by: Steve | last post by:
Hi All I have a windows application written in VB.net 2005 The users have to select a State of Australia, which I use to check they have the correct windows time zone selected in control panel...
0
1749
by: timber910 | last post by:
Ok, I have a button on a form that I'm using to create another table I will need later in my form. I have created a reference table called Ref_Table (holds my table names - using this as the tables...
5
2099
by: timber910 | last post by:
I posted this in the VB forum but I think its in the wrong place. So I thought I would try here. _________________________________________ Ok, I have a button on a form that I'm using to create...
0
7099
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6964
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7175
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
4864
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4559
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3070
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1378
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
598
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
262
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.