1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

sessiontimezone

Discussion in 'SQL PL/SQL' started by monkey, Jun 6, 2014.

  1. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    When I write select sessiontimezone from dual, it returns me words.
    I want the value in numbers.
    If I use:

    ALTER SESSION SET TIME_ZONE = '-7:0';

    how about the number part? Do I write the exact time I have on clock ?
    How if I want to go from number to words- and let's say don't know what to write in there (what timezone I am)?
    Hope U have understood what is messing me_ how to go to other option, without knowing exactly the exact values?

    (to change JUST the option, without knowing the right values!)
    Many thanks!!!
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    TIME_ZONE

     
    monkey likes this.
  3. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    I'm not sure what you need exactly but Sergey has provided all the necessary materials & links.

    Run this SQL to see it it's what you are looking for (provided you have access to this view): SQL + sample output below

    Code (SQL):
    SELECT tzname, TZ_OFFSET(tzname), tzabbrev FROM V$TIMEZONE_NAMES;

    TZNAME               TZ_OFFS TZABB
    -------------------- ------- -----
    Atlantic/Faroe       +01:00  WET
    Atlantic/Madeira     +01:00  MADT
    Australia/Canberra   +10:00  EST
    Australia/Darwin     +09:30  CST
    Australia/LHI        +10:30  LHST
    Brazil/East          -03:00  LMT
    Brazil/West          -04:00  LMT
    Canada/Central       -05:00  LMT
    ...
     
     
    monkey likes this.
  4. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Ooo, brave, u got it!!!