Hello!
In my oracle source database all timestamps are saved in UTC. Depending on the date I have to convert timestamps into Central European Time (MEZ/CET) = UTC + 1 h or Central European Summer Time = UTC + 2 h.
It would be possible to manually add 1 or 2 hours in the universe or Webi-Document, however that´s not dynamically enough.
I found the function “new_Time”, but it seems that you can only convert within timezones of the United states:
I hope somebody can give me some input or a solution.
Thank you
b.schoen (BOB member since 2011-05-03)