In DB2V10 TIMESTAMP WITH TIMEZONE has been introduced. I would like to know is there any way to convert TIMESTAMP stored in table (WITH TIMEZONE) to different timezone. For example: If the local timezone is CST then DB2 will produce timestamp in CST and adds '-05:00' as time difference between CST and UTC. Now how we can derive PST time from this time stamp?
I could not find any documentation on time conversion in internet.