Timezone/Daylight Saving Time Formula: Siebel

[flipface]

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

[Hack]

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.