Toad unable to display the region name for time zone information in Timestamps
说明
When using the region for defining time zone information in timestamps, it's not possible to see the region name in Toad's Schema Browser. Here only +01:00 is displayed.
It does show the region name in SQL*Plus, e.g. '31/01/2014 00:00:00.000000 EUROPE/BERLIN'
Also it is not possible to modify the data of the timestamp in the schema browser, as you are not able to enter the region here.
解决办法
WORKAROUND: Please run the statement in SQL*Plus
STATUS: Waiting for fix in a future release of Toad for Oracle
缺陷ID
TOR-111
其他信息
Steps to replicate:
CREATE TABLE TESTTABLE
(
TSTZ TIMESTAMP(6) WITH TIME ZONE,
TS TIMESTAMP(6)
)
LOGGING
NOPARALLEL;
insert into TESTTABLE (TSTZ, TS)
values (TO_TIMESTAMP_TZ('31/01/2014 00:00:00.000000 EUROPE/BERLIN',
'DD/MM/YYYY HH24:MI:SS.FF TZR'),TO_TIMESTAMP_TZ('31/01/2014
00:00:00.000000','DD/MM/YYYY HH24:MI:SS.FF'));
commit;
select * from TESTTABLE;
When you run the select statement in SQL*Plus, you can see the timestamp region in the results, but in Toad, it doesn't show this.
