What is the best practice for storing data in multiple time zones?

[kelleram]

I have data that has to be converted to various time zones based on what setting an account has chosen within the database. All of the data is stored in GMT. There is a function which we've built to convert the data, however, the response time when using it in queries is obviously slow. Anyone have a similar situation in the past? If so, how did you solve it? Trying to determine if adding additional fields for the timezone specific values or create MQTs off the base tables and update when needed.

[GottZ]

what language are you using?
php?
unix timestamps?
if php, then do you know that php comes with some neat date functions to handle that kind of problem?

[kelleram]

what language are you using?
php?
unix timestamps?
if php, then do you know that php comes with some neat date functions to handle that kind of problem?

Unix Timestamps so we're not using PHP