Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    61

    Unanswered: Get current timezone of OS(windows2kserver ) which sybase run on

    Hi All,

    1. I need to determine current timezone of OS(Windows 2000 Server) which Sybase run on.

    How can I do that?
    2. How can I get GMT time in Sybase?

    Thanks for your help,
    Thi Nguyen

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Code:
    select getdate()
    or
    Code:
    xp_cmdshell "any OS command"
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

  3. #3
    Join Date
    Jul 2004
    Posts
    61
    Hi Fadace

    Gettime() just returns localtime, but I want get GMT time.
    How can I get timezone of OS?

    Thanks
    Thi Nguyen

Posting Permissions

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