Icon

kn_​forum_​28902_​db_​sqlite_​datetime_​timestamp_​strftime

SQLite - handle DATETIME and TIMESTAMP variables in KNIME
SQLite - handle DATETIME and TIMESTAMP variables in KNIMEhttps://forum.knime.com/t/sqlite-datetime-to-knime-format/28902/12 knime://knime.workflow/data/home-assistant_v2.dbSELECT sql FROM sqlite_master WHERE name='states';, strftime("%Y-%m-%d %H:%M:%S", "last_changed") as last_changed_time, strftime("%Y-%m-%d %H:%M:%S", "last_updated") as last_updated_time, strftime("%Y-%m-%d %H:%M:%S", "created") as created_timeknime://knime.workflow/data/new_db.sqlitenew_statesnew_statesnew_statesSELECT sql FROM sqlite_master WHERE name='new_states'; SQLite Connector DB Query Reader DB Query Reader DB Query Reader String to Date&Time DB Table Selector DB Query DB Reader SQLite Connector DB Table Creator DB Writer DB Table Remover DB Query Reader SQLite - handle DATETIME and TIMESTAMP variables in KNIMEhttps://forum.knime.com/t/sqlite-datetime-to-knime-format/28902/12 knime://knime.workflow/data/home-assistant_v2.dbSELECT sql FROM sqlite_master WHERE name='states';, strftime("%Y-%m-%d %H:%M:%S", "last_changed") as last_changed_time, strftime("%Y-%m-%d %H:%M:%S", "last_updated") as last_updated_time, strftime("%Y-%m-%d %H:%M:%S", "created") as created_timeknime://knime.workflow/data/new_db.sqlitenew_statesnew_statesnew_statesSELECT sql FROM sqlite_master WHERE name='new_states'; SQLite Connector DB Query Reader DB Query Reader DB Query Reader String to Date&Time DB Table Selector DB Query DB Reader SQLite Connector DB Table Creator DB Writer DB Table Remover DB Query Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: dchabauty
Created at: 2020-11-24
On NodePit since: 2020-11-27
Last update: 2024-05-01
Created with KNIME version: v4.2.3
Tags: sqlitedatetimetimestamp

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!