In DBExplorer from Oracle DB timestamp is not dipslayed(Unknown) when in DB is defined as TIMESTAMP WITH TIMEZONE. TIMESTAMP alone displays OK.

MyE:

Version: 5.0.0
Build id: 20060805-5.0-GA

E:
wt.toolkit=sun.awt.windows.WToolkit
eclipse.buildId=M20060629-1905
eclipse.commands=-os
win32
-ws
win32
-arch
x86
-launcher

What JDBC driver did you configure to connect to the Oracle DB? Also which version of Oracle are you using?

asdf999 ,

Oracle's JDBC driver return correct type for TIMESTAMP (TIMESTAMP=93) and nonstandard jdbc values -101,-102 for TIMESTAMP WITH TIMEZONE and
TIMESTAMP WITH LOCAL TIMEZONE.MyEclipse return 'Unknown' for every nonstandard type (or types OTHER=1001).I will file internal request for enhancement and we will try fix this.

Regards,
Peco