Need help with timezone format

[former_member213259]

I have a datetime format object which is in GMT timezone and now I need to convert it to CDT (central daylight time). I am using BO 4.1 SP1 and my universe is multisource enabled with Oracle 11g as backend. Any help on this would be appreciated.

[CdnConnection]

Sowrabha,

     You will need to update the SQL for the Time Object, see exaample below

NEW_TIME(TABLE.COLUMN,'GMT','CDT') AS TIME

Regards,

Ajay

[former_member4998]

Hi

Can you please provide some example data...