American time

[Wayne-I-M]

Hi all

Does the USA have daylight saving (or something like it).

This "is" an access question....

I have a database that provides a client who books a trip with the total
flying time to various countries. It's a little mad sometimes
eg - we run trips to Peru (which does have daylight saving) but the client
finish in Ecuador for a few days (which doesn't) before flying to the
Carribean for a fews days (which does), etc, etc. Add this the fact the some
of the trips take place over the time switchover.... blah blah as you can see
a bit mad (flight time issue by airline work on Local times so don't give the
total flying time).

We have just started running trips to the USA so......

If it does have daylight saving is it the same all over the US (length and
switchover dates)

The only info I have managed to get up to now is
http://en.wikipedia.org/wiki/Daylight_saving_time
but this does not give enough info. Is there a website that gives the
details??


Many thanks

 

[B]

Yes it does, and from what I know they all switch at the same time. Howver,
the state of Arizona does not switch at all. There should be a web site that
would tell you all this. I used to travel for the Air Force and I was
actually in a country that only changed 1/2 hour instead of the normal hour.
Good thing we used Z time. Good luck sounds like a crazy formula that you
have to write. Maybe someone already did it?

 

[Wayne-I-M]

Never been to USA but I think they have the internet there by now. So maybe
someone has learnt to make websites and will have put the daylight times up.??

Howver, the state of Arizona does not switch at all.

You have to laugh. The trips we run are to the Grand Canyon - which I
"think" is in Arizona. (No doubt someone will tell me if it isn't)

Good luck sounds like a crazy formula that you
have to write. Maybe someone already did it?

I have already written the d'base. It works fine (except for the USA which
I am just adding in). The 5 admin office use it to issue tickets and travel
info - part of which is flying time.

I used to travel for the Air Force and I was
actually in a country that only changed 1/2 hour instead of the normal hour.

We run trips to Nepal as well - which changes by 15minutes from Indian time
(but not on the same date - why? not a clue)

 

[Larry Linson]

Never been to USA but I think they have the
internet there by now. So maybe someone has
learnt to make websites and will have put the
daylight times up.??

Wal, we're workin' on it, Wayne. We're puttin' up telegraph poles all along
the railroad tracks, but most of our information still comes from

You have to laugh. The trips we run are to the Grand
Canyon - which I "think" is in Arizona. (No doubt
someone will tell me if it isn't)

It was in Arizona, last time I was there. And, it looked to me like it would
be a real heavy-duty, industrial-strength chore to move it anywhere.

I have already written the d'base. It works fine
(except for the USA which I am just adding in).
The 5 admin office use it to issue tickets and travel
info - part of which is flying time.

There are multiple time zones in the US... three in the continental US
states, and others in the states of Alaska and Hawaii. There are also US
possessions in the Caribbean, some of which are on US Eastern Standard or
Daylight Time, and in the Pacific. Those are well-documented, so should not
be a problem. And, as far as I know, the switchover to Daylight Savings Time
and back is a federally-mandated date.

Obviously, a state (witness Arizona) can opt-out of using the switch. It is
the only state which does, as far as I know. I am not aware if a state can
choose a different date, but don't know of any who do.

Larry Linson
Microsoft Access MVP

 

[Dirk Goldgar]

In

The only info I have managed to get up to now is
http://en.wikipedia.org/wiki/Daylight_saving_time
but this does not give enough info. Is there a website that gives the
details??

If you chase enough links from there, you'll find this:

http://www.twinsun.com/tz/tz-link.htm
Sources for Time Zone and Daylight Saving Time Data

It appears to be Unix-oriented.

Time zone information is encoded in the Windows registry. See this MSKB
article for details:

http://support.microsoft.com/kb/221542/en-us
How to change time zone information by using Visual Basic

You may find this handy:

http://www.timezoneconverter.com/cgi-bin/tzref.tzc
Time Zone Reference Card - Compare Multiple Time Zones
The Time Zone Converter Reference Card compares the time
in multiple time zones against a reference zone, displaying the
difference in time between each selected time zone and the
reference zone.

Need to coordinate meetings, teleconferences, or other events
between different time zones? Just select your time zone as the
reference zone and then select the check box for each time zone
you want to compare. Press Submit and the Reference Card will
display the difference in time between your time zone and
each selected time zone.

Print the results for a convenient reference you can carry with you
or keep near your desk.

 

[Wayne-I-M]

Many thanks Larry and Dirk.

It seems the one place our clients will going don't have daylight saving
hours so that makes it a little bit easier. But - as always - I will add a 1
minute daylight saving on March 1st and back again on Nov 1st (to
tblaylight). It's better to have some thing that simple to change than not
bother doing it. Don't think the clients will mind arriving 1 min early.

Many thanks again

 

[Brendan Reynolds]

In

If you chase enough links from there, you'll find this:

http://www.twinsun.com/tz/tz-link.htm
Sources for Time Zone and Daylight Saving Time Data

It appears to be Unix-oriented.

Time zone information is encoded in the Windows registry. See this MSKB
article for details:

http://support.microsoft.com/kb/221542/en-us
How to change time zone information by using Visual Basic

You may find this handy:

http://www.timezoneconverter.com/cgi-bin/tzref.tzc
Time Zone Reference Card - Compare Multiple Time Zones
The Time Zone Converter Reference Card compares the time
in multiple time zones against a reference zone, displaying the
difference in time between each selected time zone and the
reference zone.

Need to coordinate meetings, teleconferences, or other events
between different time zones? Just select your time zone as the
reference zone and then select the check box for each time zone
you want to compare. Press Submit and the Reference Card will
display the difference in time between your time zone and
each selected time zone.

Print the results for a convenient reference you can carry with you
or keep near your desk.

Vista has some useful time-zone related features built-in. You can add
additional clocks in different time zones to the system-tray clock or to the
Vista 'Sidebar'.