tzh in compare table data

[Jason King]

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 HH24:MI:SS.FF TZH:TZM')
WHERE DAY_RATE_ID = 8;
or
UPDATE LANE_GROUP_DETAILS T SET MODIFIED_DATE = TO_TIMESTAMP_TZ('2006/06/06 19:06:53.97000000 251:00', 'YYYY/MM/DD HH24:MI:SS.FF TZH:TZM')
WHERE LANE_GROUP_DETAIL_ID = 60;

which oracle complains about since the tzh isn't between +12 and -13. Subtracting 256 from the number pl/sql dev uses produces valid output, but I'd prefer to just be able to run the generated scripts.

It may be my setup in which case I'll be happy to make changes so compare table data works all around.

Here's my version info:
PL/SQL Developer
Version 7.0.3.1123 (MBCS)
Windows XP version 6.0 (build 2600) Service Pack 2

Using
Home: DevSuite
DLL: E:\oracle\devsuite\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Character size: 1 byte(s)

 

[Marco Kalter]

This would seem like a bug. We'll look into this. I don't immediately have a workaround.

 

[Jason King]

Will this fix be in 7.1? Is there anything I can do to facilitate getting this fix in?

 

[Marco Kalter]

Yes, this will be in 7.1.

 

[Jason King]

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 facilitate a fix. My suspicion is it involves some sort of if (houroffset > 12) houroffest := 256 - houroffset; but I can't see the code to do the change.

 

[Marco Kalter]

This isn't fixed yet? We'll check it out!

 

[Jason King]

Any updates on this?