Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    364

    Unanswered: TimeZone Problem

    I just inherited a system that was running on a server in the central timezone and has been relocated to the eastern timezone. All times stored in the db are central time. Since the move any db code that uses sysdate is causing problems. Eastern times are being inserted instead of central. Is there an easy way to offset the time? Also, the test servers are located in the central timezone so whatever solution I use has to work on both servers in both timezones. So the solution isn't as simple as refactoring sysdate to sysdate - 1/24.

    Anyone have suggestions?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Keep the timezone on the server at Central time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •