DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How do you find out the timezone in which the server runs?

  1. #1
    Join Date
    Oct 2003
    Posts
    27

    How do you find out the timezone in which the server runs?

    How do you find out the timezone in which the server runs?

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    HP/UX...set |grep TZ

    NT, net-op in and check.

    Or are you talking about getting this info from a SQL session?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Oct 2003
    Posts
    27
    from SQL session or from OEM

    Say, you have serveral servers running in different areas.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    Well, you can use the above commands with the HO (short for HOST)command first.

    SQL> HO set |grep TZ


    We had this topic a few months ago but I can not find it, but I remember there being a dictionary view that had this info.
    So much for my short term memory.



    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    SELECT TZ_OFFSET(SESSIONTIMEZONE), TZ_OFFSET(DBTIMEZONE) FROM DUAL;

    For detail refer the metalink note:

    Note:227334.1
    Subject: Dates, Timestamps & Timezones - Frequently Asked Questions


    Sam
    Last edited by sambavan; 10-24-2003 at 06:12 PM.
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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


Click Here to Expand Forum to Full Width