Convert Time Zone

  • Thread starter Thread starter ServiceEnvoy
  • Start date Start date
S

ServiceEnvoy

I am building a database to track ebay auctions and they are all
listed as PDT time. I have a field called "localtime". Is there a
way to set the "localtime" field to look at the "PDTTime" field and
automatically calculate the local time?
 
You need to identify the time zone for each location as an offset from GMT or
Zulu time. GMT would be 0 The next time zone to the east is GMT - 1.

Now, there are a couple of places in the world that don't adhere to that
basic concept. Newfoundland, for example is 1/2 hour off the standard time
zone. I think there are one or two more, but I don't know where they are.

I would google for it. I would bet someone already has done this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

This should be easy as pie: convert local to UTC and back 7
How convert GMT to LocalTime in Access 2003 8
datacolumn datetime from UTC to Localtime 2
How to Convert UTC to localTIme(C# ) 5
IsDayLightSavingTime doesn't work for 2007 and beyond 3
convert UTC to local time(system time) and vice vesra in VB.NET 1
Not All Fields Update my Table from my Form 5
sending message on various timezones 1

Back
Top