[AccessD] Comparing times in different time zones

Kenneth Van Huss kvanhuss at airrsystem.com
Mon Oct 24 23:25:34 CDT 2011


If captain Kirk could have a univerdal "stardate" surely we have one universal time that could be used here on our planet.    

Sent on the Sprint® Now Network from my BlackBerry®Kenneth Van HussVanGard SystemsOffice (214) 801-4357 ext 335Fax    (214) 299-8597Cell    (214) 243-5659================================================================This message and all attachments transmitted with it may containlegally privileged/proprietary information intended solely forthe use of the addressee. If this email is not intended for you,and you are not responsible for the delivery of this email messageto the addressee, do not keep, copy or deliver this email messageto anyone. Please destroy this email in its entirety and notifythe sender by reply email. Your cooperation is appreciated.==================================================================In consideration of the environment – please do not print  this emailunless absolutely necessary.

-----Original Message-----
From: Darryl Collins <darryl at whittleconsulting.com.au>
Sender: accessd-bounces at databaseadvisors.comDate: Tue, 25 Oct 2011 03:27:19 
To: Access Developers discussion and problem solving<accessd at databaseadvisors.com>
Reply-To: Access Developers discussion and problem solving
	<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Comparing times in different time zones

Bloody hell Ken,

That is going to be a struggle to get right given all the Local time zones you are going to need to deal with. Just in Oz alone it is a mess with some states on Daylight saving time and other states ignore it.  This leads to stupid situations where you will have two cities in the same zone being 1 hour apart.

I am sure Australia doesn't have a monopoly on this sort of weirdness.

I deal a lot with Asia and the US and Africa these days so I use this website <<http://www.timeanddate.com/worldclock/>> to keep track of different times, maybe it can help you out?

I guess it depends on where you are grabbing the offset from and if it is automatically updated or not?


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth W Van Huss
Sent: Tuesday, 25 October 2011 2:13 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Comparing times in different time zones

I have an unmet challenge relating to comparing times in different time
zones.  User on the other side of the world, literally enters time of an
event.  When the user saves the record in the database that time is
captured, though the time is the server time, located in US central time
zone.  Using UTC offset I have "normalized" the times to UTC to compare
against one another to ensure the record was entered within a certain amount
of time.  The challenge I see down the road is Day Light Savings time and
the impact that will have on the offset.  Anyone experience this before?

 

Thanks!

Ken

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list