oracle timestamp 截位,Oracle中的“timestamp with time zone”类型保留时区格式

我有你的问题,但我仍然认为这取决于工具在我的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.