I am using the following SQL in the Knime Database Reader node with Oracle Driver:
SELECT
TO_DATE(SYSDATE, 'yyyy-mm-dd HH24:mi:ss') “NOW”
FROM DUAL
The result contains the correct Date but the time is always 00:00:00.
If I run the same query Oracle LiveSQL or DBfiddle I have the accurate time as well.
See: DBfiddle
The reason I think it works in DBfiddle and LiveSQL is because I am setting NLS_DATE_FORMAT.
How do I set the NLS_DATE_FORMAT for the Database Reader node in Knime?
