KNIME Database Reader (datetime field read as date only)

KNIME Analytics Platform
1

Hello everyone,

 

I have a slight problem with getting my data from SQL Database. I would like to get the data from the last three days from my datetime field, and everything is going well, except KNIME Database Reader changes my datetime field to only date.

 

I have tried to look for any documentation on this topic but i haven't found any...There are not even any relevant settings in KNIME Database Reader that would prevent reading my datetime field as a date.

 

Help would be appreciated!

 

Thanks

2

Hi,

usually KNIME is automatically using the right data format based on the returned database column type.

What database you are connecting to and what JDBC driver are you using? It would be also interesting to know the type of the date and time column.

Thanks

Tobias