Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    5

    Unanswered: sybase server time Vs OS time.

    Hello:

    The TimeZone setting of the OS (SunSOlaris 10) , that Our sybase ASE server runs on, is being changed from CT to GMT. For ages now, all our applications and data are at CT. We want to retain this and avoid overhead of conversion.

    Question 1 : I want to know if there is any option to reset sybase server time independent of the OS time. Meaning that even though the OS time is at GMT, getdate() function returns time in CT. We want to avoid doing this conversion in the clients.


    Question 2 : If it is not possible or practical to change syb server time, can we override the getdate() function ?

    Thanks in advance.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Set the TZ variable in your RUN_server file

  3. #3
    Join Date
    Sep 2006
    Posts
    5
    Thanks. updating the RUN file was what we did .

Posting Permissions

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