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
Did anyone encounter this, are there any options to change it ?
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.