Error writing data to sqlite database

Trying to create a table in sqlite but get an error shown as follows:

ERROR DB Writer 3:7 Execute failed: Output type mappings are missing for columns:
Create_Date (Date and Time)

the datatype in knime is a datetime but apparently it doesn’t map correctly to a datetime datatype in sqlite. I see the mapping dialogue but not sure how to configure it to be able to write a sqlite datetime.

Any pointers to how I do this?

Thanks,
Jeff

@Jeff SQLite indeed is a bit picky about date and time variables. I have toyed around with several examples you might want to check out:

1 Like