DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Question Timezone/Daylight Saving Time Formula: Siebel


    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
    Apr 2007
    Sterling Heights, Michigan
    Even those dates are not hard and fast....

    Regadless, why do you need to worry about this programmatically? The system clock on the users computer should update the time properly.

Similar Threads

  1. query tuning
    By dhaya in forum Database
    Replies: 11
    Last Post: 08-25-2003, 05:24 PM
  2. What's the right time????
    By Coilin Riley in forum Java
    Replies: 2
    Last Post: 05-31-2001, 03:26 PM
  3. API DST (Day light saving Time)
    By TiBlay in forum VB Classic
    Replies: 2
    Last Post: 10-21-2000, 01:44 PM
  4. API DST (Day light saving Time)
    By TiBlay in forum VB Classic
    Replies: 0
    Last Post: 10-20-2000, 03:48 PM
  5. Re: search for time !!!Error!!!
    By kammy in forum VB Classic
    Replies: 0
    Last Post: 05-01-2000, 04:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center