SQL Server and Daylight Savings Time

  • We have an application that contains time based processing.

    When clocks are moved back in the Autumn (Fall) there is obviously the possibility of overlapping times (something done an hour earlier would have the same time a something done now).

    Setting servers to use UTC time, and adjusting the time display at the client end is an obvious solution, but would mean a fair amount of re-coding. There would then also the task of updating the existing data to reflect UTC time, rather than the local time.

    The solution in the previous version of the system was to switch everything off for an hour.

    Has anybody come across a more elegant solution to this problem?

  • This was removed by the editor as SPAM

  • I just posted recently about having to deal with time issues because we're crossing time zones at the app level now. Definitely a lot of work to change everything to UTC. Lucky enough not to have issues with time change, typically only have jobs that are not critical running during that time. Don't know that the solution you propose isn't elegant enough!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply