DB SQL - H2 Database dynamic Query with datetime

Use a VIEW that selects the latest Timestamp and then use a merge to only keep the latest one. In this case it is the same table but this could be used on different tables

Create a DB Query in KNIME to only give back the latest values after a certain date

https://forum.knime.com/t/row-filter-on-database-level-to-only-get-incremental-load-of-data/83720/9?u=mlauber71

SELECT * FROM "PUBLIC"."sample_table"

WHERE "Zoned Date Time" >= (SELECT MAX("Zoned Date Time") FROM "PUBLIC"."sample_table")

SELECT * FROM "PUBLIC"."sample_table"

WHERE "Zoned Date Time" >=

TIMESTAMP '$${Svar_max_time}$$'

KNIME, Databases and SQL

https://medium.com/p/273e27c9702a

prepare data to have several different dates

CREATE VIEW IF NOT EXISTS "PUBLIC"."v_max_timestamp" AS

SELECT MAX("Zoned Date Time") AS "Max Zoned Date Time"

FROM "PUBLIC"."sample_table"

Create a H2 table "sample_table"

Bug in the Date Shifter Node

https://forum.knime.com/t/date-shifter-how-to-pass-a-negative-day-shift-in-a-flow-variable/90592/7?u=mlauber71