Daylight saving change proves thorny for businesses

TalkBack 9 of 24:

Next »

« Previous

• Thread View
• Flat View

It's bigger than just calendars

Most databases store time in UTC format. They convert the local time to GMT and store it in the database. So if you scheduled a critical business process 2 months ago before being patched to run on 3/12 at 1pm EST, it was recorded in the database as 3/12 6pm GMT. Now, applying the patch, what do we do with that time? Did you really want it to run at 1pm EST, which would now be 5pm GMT based on the new rules, or was that time based on other international users and it still needs to be 6pm GMT? If it's software that runs a factory or controls international shipments, that 1 hour difference may make a big difference.

Posted by: GreenChild   Posted on: 03/09/07 You are currently: a Guest | Members login | Terms of Use

Alert moderator to an offensive message

Subscribe to this discussion via Email or RSS

SponsoredWhite Papers, Webcasts, and Downloads

• Live Webcast: Activate Today! Realize ROI with Intel(r) vPro Technology and Microsoft System Configuration Manager Intel Join the team from the Intel vPro Expert Center for an informative Webcast ... Download Now
• Three Steps You Need to Know to Stop Data Loss Varonis Sensitive data exposed to misuse or loss... it is the stuff of nightmares ... Download Now
• Climatologist Douglas Hardy Travels to Glaciers in the Highest Places on Earth, Where His Dell Latitude ATG Works Every Time Dell The primary goal of the expeditions is to glaciers at 19,000 feet and ... Download Now