Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Question Unanswered: Timezone/Daylight Saving Time Formula: Siebel

    Hello,

    I'm developing a Siebel Analytics report and one of the requirements is to convert datestamp, which is in GMT, to Eastern Time U.S.

    I understand that it is Eastern time is GMT -5 from second sunday of March at 2am to first sunday of November at 2am and GMT -4 any months outside of that.

    I'm new with Siebel Analytics, and I'm not sure in how to construct an SQL formula to convert the datestamp.

    I hope you can be an assistance to my delema.

    Thanks in advance!
    Edit/Delete Message

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    You can query the needed offset using the TZ_OFFSET() function:

    SELECT TZ_OFFSET('US/Eastern') FROM DUAL;

    It will correctly apply the DST rules (based on the time zone of your server)

    Btw: what is "datestamp"?

    In Oracle you either have DATE or TIMESTAMP, but there is no DATESTAMP data type.

    Edit: this example shows how to convert from one timezone to another:
    http://www.devx.com/dbzone/Article/30501/0/page/3

    So you should be able to simply select your timestamp column using:
    Code:
    SELECT timestamp_column AT TIME ZONE  'US/Eastern'
    FROM the_table;
    Last edited by shammat; 04-02-09 at 19:00.

Posting Permissions

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