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.
Does this help?
http://www-01.ibm.com/support/docview.wss?uid=swg21339907 (http://www-01.ibm.com/support/docview.wss?uid=swg21339907)
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.