Calculating the Time In A Time Zone

G

GHF

I have a database where every record in a certain table is assigned to a Time
Zone, mostly in North America, but also around the world.

What I would like to do is to have a field on a form that takes the current
system time, and calcuates the time at that location, so I can see it without
some sort of mental gymnastics.

For example, I am in the Eastern Time Zone, and the system time on my system
says so. I know that anything in the Central Time Zone is one hour behind.

If I know that, how do I calculate that the current time in Chicago is 1722,
when the current system time is 1822 here in Orlando?
 
D

David

What I do is enter dates the database in GMT (UDT) date/time.

This way all date/times are on the same timezone base when entered.

This facilitates an easy SQL date / time search.

Date / Time displays to users are adjusted to their timezome from this UDT
base.
 

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

Top