Reports to Display Time Fields Dynamical As Per Users Setting Time Zone

[Neelam Bhatia]

My requirement is to dynamically convert the timezone of the Time fields as per the time zone of the user system.

For example:, if the the date/time field is a timestamp that indicates when a record is updated, and assuming that this timestamp reflects the date/time of the host database, then it probably should be converted.

Specifically, if the host database were in Washington, DC, USA, and a customer in Seoul, Korea modifed a record, the timestamp of that record would contain the Washington time, not the Seoul time (13 hours difference). If the customer then looked at the record that was changed, he/she would expect the date/time to be expressed in Seoul time, not Washington time, thus the need for it to be converted.

I would consider your inputs as Great and much appreciated.

[bdbits]

Does this help?

http://www-01.ibm.com/support/docview.wss?uid=swg21339907

[Neelam Bhatia]

Thank you for ur reponse.

This link says to convert the timezone using new query item. But i want to convert the timezone of the existing query item of database.