Timezone/Daylight Saving Time Formula: Siebel


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Timezone/Daylight Saving Time Formula: Siebel

  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Question 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
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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