Please connect via Oracle SQLNet and execute
Code: Select all
alter session set NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR';
select TIMESTAMP '1999-10-29 01:30:00 US/Pacific PDT' from dual
The result is as expected
Code: Select all
29-OCT-99 01.30.00.000000000 AM US/PACIFIC
The result is erroneous:
Code: Select all
03-NOV-99 07.06.00,000000000 AM +117:96