How do I set the NLS_DATE_FORMAT for the Database

Question

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?