Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    4

    Unanswered: Database Timezone

    Hi,

    Check this query

    Code:
    SELECT *
    FROM V$TIMEZONE_NAMES
    WHERE TZNAME = 'America/New_York'
    
    TZNAME                  TZABBREV
    
    ---------------------------
    America/New_York    LMT
    America/New_York    EST
    America/New_York    EWT
    America/New_York    EDT
    As you can see from the above query that America/New_York is having 4 timezone abbreviations but i want only EST.

    Now i want to set database timezone to America/New_York EST, please tell me how can i do that since while executing following command i only have the option of specifying America/New_York and not EST

    Code:
    Alter Database Set Time_Zone = 'America/New_York';
    Kindly guide me


    Regards
    Last edited by taste_oracle; 06-26-10 at 01:37. Reason: To make my doudt more clear

  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    This document will show you the different options you have:
    datetime

  3. #3
    Join Date
    Jun 2010
    Posts
    4

    Thanks

    This does not answer my question sir

Posting Permissions

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