我有你的问题,但我仍然认为这取决于工具在我的toad中,以下测试用例返回相同的结果:
create table test_a(
id number,
column_a timestamp with time zone
)
;
insert into test_a(id) values(1);
insert into test_a(id) values(2);
update test_a
SET COLUMN_A = TO_TIMESTAMP_TZ('19-JUL-18 01.53.16.381566000 PM UTC',
'DD-MON-RR HH.MI.SSXFF AM TZR')
where id = 1;
update test_a
SET COLUMN_A = TO_TIMESTAMP_TZ('19-JUL-18 01.53.16.381566000 PM +00:00',
'DD-MON-RR HH.MI.SSXFF AM TZH:TZM')
where id = 2;
select * from test_a;
ID COLUMN_A
---------- -----------------------------------
COLUMN_B
-----------------------------------
1 2018-07-19 13:53:16.381566 +00:00
2 2018-07-19 13:53:16.381566 +00:00
2 rows selected.