Shawn, You might want to check out the GetTimeZoneInfo() function. From the docs:
GetTimeZoneInfo Description Returns a structure that contains time zone information for the computer on which it is executed. The structure contains four elements with the following keys: * utcTotalOffset offset of the local time, in minutes, from Universal Coordinated Time (UTC). A plus sign (+) indicates that a time zone is west of UTC, such as the time zones in North and South America. A minus sign (-) indicates that a time zone is east of UTC, such as the time zones in Germany. * utcHourOffset offset, in hours of local time, from UTC. * utcMinuteOffset offset, in minutes, after the hours offset is taken into account. For North America, this is always 0. For countries that are not exactly on the hour offset, the number is between 0 and 60. For example, standard time in Adelaide, Australia has an offset of 9 hours and 30 minutes from UTC. * isDSTOn True if Daylight Savings Time (DST) is on in the host; False if DST is off. Category Date and time functions Syntax GetTimeZoneInfo() See also DateConvert, CreateDateTime, DatePart Example <html> <head> <title>GetTimeZoneInfo Example</title> </head> <body bgcolor = silver> <H3>GetTimeZoneInfo Example</H3> <!--- This example shows the use of GetTimeZoneInfo ---> <cfoutput> The local date and time are #now()#. </cfoutput> <cfset info = GetTimeZoneInfo()> <cfoutput> <P>Total offset in seconds is #info.utcTotalOffset#.</P> <P>Offset in hours is #info.utcHourOffset#.</P> <P>Offset in minutes minus the offset in hours is #info.utcMinuteOffset#.</P> <P>Is Daylight Savings Time in effect? #info.isDSTOn#.</P> </cfoutput> </body> </html> > -----Original Message----- > From: Shawn McKee [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 4:01 PM > To: CF-Talk > Subject: Daylight savings time > > > I have applications that deliver content in a time sensitive manner. We > store times in our database in UTC (GMT). Whenever a country changes from > or to standard time I catch a lot of grief because release times > have to be > manually updated. Anybody know of a tool, CF or otherwise, that > can help me > solve the problem of update the UTC stored based on some sort of location > parameter. > > Shawn McKee ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
