Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443

    Unanswered: getdate() wrong from system time

    Hi,

    Anyone seen this before. (v11.9/solaris)

    1> select getdate()
    Jan 26 2007 10:18AM
    $date
    Fri Jan 26 11:18:56 MET 2007

    Theres exactly a one hour difference. We are not setting any TZ variable in the RUN file.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    This has nothing to with the RUN file. You should check the user that starts ASE, check the profile for this user, there has to be a TZ associated which is causing this.

Posting Permissions

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