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?