Wrong daylight savings time display with type TIMESTAMP(6) WITH LOCAL TIME ZONE. (4225204)

Given a database with the DST (daylight savings)patch applied, it becomes evident that Toad does not display the correct time for type TIMESTAMP(6) WITH LOCAL TIME ZONE when considering day-light-savings.

You can run the following scripts to see the error. On databases with the DST patch, SQL Plus will have a different output than Toad.

CREATE TABLE TS_TEST
(TSLTZ TIMESTAMP(6) WITH LOCAL TIME ZONE,
TS TIMESTAMP(6));

ALTER SESSION SET TIME_ZONE=CST;
--- Note: You can get a list of valid time zone strings from V$TIMEZONE_NAMES.

INSERT INTO TS_TEST VALUES (TO_TIMESTAMP (2007-11-07 14:00:00.000000, yyyy-mm-dd hh24:mi:ss.ff6),
TO_TIMESTAMP (2007-11-07 14:00:00.000000, yyyy-mm-dd hh24:mi:ss.ff6));

SELECT * FROM ts_test;

WORKAROUND:
None

STATUS:
Waiting for fix in a future release of Toad for Oracle.