SQLite DATETIME to Knime format

Hi everyone,

New to Knime, I went through some tutorials and got a basic understanding of the tool.

Right now, I setup a small flow to read data from an SQLite database but face an issue with the date/time format.

The database contains a “State” table with a column named last_changed. According to DB Browser, the type of this column is DATETIME, and it contains the date and time of the event.

I used the SQLite connector in Knime which loads the data successfully. Then I use a DB Query reader to only acquire a subset of data. It works well and I can see the data in the data table.

The problem is that the last_changed column only contains the date. The time is gone.

Looking into the SQLite connector Input Type Mapping, I only see DATE, no DATETIME.

From testing, I can see that the SQLite Connector sees the last_changed column as a DATE type, not a TIMESTAMP or other format.

How can I go around this problem? The timestamp is essential to the analytics I want to perform.

Thank you,

Dominique