Getting incorrect datetime from Oracle Query

Hello All,

I am using the following SQL in the Database Reader node with Oracle:
TO_DATE(SYSDATE, ‘yyyy-mm-dd HH24:mi:ss’) “NOW”

The result contains the correct Date but the time is always 00:00:00.

This query works in Oracle Workbench. I am not sure why it is not working in Knime

Any ideas?

Maybe Workbench is wrong? Oracle’s LiveSQL ( ) returns a TO_DATE as indeed a date without a calculated time of day attached (as the docs seem to imply ), using TO_CHAR returns a string representing the format specified.

@quaeler, you have to set the NLS_DATE_FORMAT with LiveSQL. For e.g. see:


Ah - good to know. Sorry for the red herring.