Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008
    Location
    Atlanta, GA
    Posts
    14

    Unanswered: Changing Time Zone in Oracle 10g

    Hi,

    How can I change the timezone in Oracle 10g to reflect GMT -05:00? Currently, the time zone is GMT- 04:00

    SQL> select systimestamp from dual;

    SYSTIMESTAMP
    ---------------------------------------------------------------------------
    24-OCT-08 12.58.29.906000 PM -04:00

    SQL>

    Thanks,
    Anthony

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How can I change the timezone in Oracle 10g to reflect GMT -05:00?
    By changing the timezone of the Operating System upon which Oracle runs,
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2008
    Location
    Atlanta, GA
    Posts
    14
    Interesting... The OS Timezone in Windows XP says "(GMT-05:00) Eastern Time (US & Canada)". I am not sure why the database time says
    "SYSTIMESTAMP
    ---------------------------------------------------------------------------
    28-OCT-08 03.40.08.796000 PM -04:00"

    Any thoughts?

    Thanks,
    Anthony

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    patch the database.

    Also, it could just be your client so upgrade your client to 11g.
    I had this issue using a 10.1.0.1 client on windows.
    I upgraded the client to 11g and the issue was gone.

    has to do with the new daylight savings time changes
    (the dates when the US changes their clocks).
    otherwise, just wait 2 weeks and your problem will magically disappear! wheeee!
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    May 2008
    Location
    Atlanta, GA
    Posts
    14
    You are correct! The problem has "magically" disappeared... Definitely DST related.

    Thanks,
    Anthony

  6. #6
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Quote Originally Posted by PianoManBflat
    You are correct! The problem has "magically" disappeared... Definitely DST related.

    Thanks,
    Anthony
    Was there actualy a "problem"? GMT -04:00 was correct until 2:00 AM November 2nd. Then we came out of EDT (GMT -04:00) and back into EST ( GMT -05:00)

    This assumes that the original poster is in the Eastern Standard Timezone and observes Daylight Savings Time. Maybe that assumption is incorrect?

Posting Permissions

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