I suppose its unfair to bring back a 5 year old post, but since the fix wasn't in 7.1 or 8 or 9 when might we benighted folks from the new world be able to use timestamps with time zones in data compares w/o having to hand fix the data?
I'll be happy to provide sample data or whatever would...
I'm in the USA where timezone hours are negative.
When I do a compare table data on tables w/ timestamp with time zone columns the tzh part comes out as a large negative number. examples:
UPDATE DAY_RATES T SET DATE_MODIFIED = TO_TIMESTAMP_TZ('2006/12/04 02:01:10.531000000 250:00', 'YYYY/MM/DD...