Display of Oracle Timestamp s

KNIME Analytics Platform
1

Dear all,

I'm accessing an Oracle DB (11.2.0) Table with a timestamp field.

The timestamps in the Oracle SQL developer are displayed like:

16.07.14 21:43:48,424000000 +02:00  

Colum Format TIMESTAMP(9) WITH TIME ZONE

strangely KNIME (v 2.10.3) displays the timestamp values like

oracle.sql.TIMESTAMPTZ@13cdd302

Did anyone encounter this, are there any options to change it ?

2

According to: 

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions200.htm#SQLRF06129

You might be able to use something like: 

SELECT TO_CHAR(ts_col, 'DD-MON-YYYY HH24:MI:SSxFF') AS ts_col,

to get a character string and then use a string to date/time node to convert it to a normal java time stamp.  There might be a way to do it in DB with some other stored procedure but I don't know what that would be off the top of my head.