Dealing with different timezones

[diddy]

Hi,
In our raw data we store the time in UTC. For various client reports, we have to use the client specific timezone. Is there a way to implement this in a metadata model without having a complex lookup table?

[mgie]

Hi!
I had a similar problem and I solved it using the databse to translate the field.
I wrote an oracle function utc_to_local() that i call when i want to retrieve the time in local zone. In the report I use an advanced datasource so that i can switch between the
local and the utc field (from the metadatamodel).
On the platform you can subclass the mql query generator and switch the field in there (maybe based on a user setting).

If you found an easier solution please let me know.

cheers,

mgie