Icon

kn_​forum_​42766_​db_​postgres_​date_​varaible

PostgreSQL - filter date variables

PostgreSQL - filter date variables

PostgreSQL - filter date variables Input a date data_insert_typestest_data_all_types123456data_insert_typesdata_insert_typesNode 1896Node 1898Node 1899Shift the date randomly+/- 5 daysNode 1901WHERE "Local Date">= '$${SMedian(Local Date)}$$'Median of all Datesdate-inputWHERE "Local Date">= '$${Sdate-input}$$'FlowVariables DB Table Remover Test Data Generator prepare_data Column Rename PostgreSQLConnector DB Table Creator DB Insert Random NumberAssigner Round Double Math Formula Date&Time Shift Column Filter GroupBy DB Query Table Rowto Variable Date&TimeConfiguration DB Query DB Reader DB Reader DB Row Filter DB Reader PostgreSQL - filter date variables Input a date data_insert_typestest_data_all_types123456data_insert_typesdata_insert_typesNode 1896Node 1898Node 1899Shift the date randomly+/- 5 daysNode 1901WHERE "Local Date">= '$${SMedian(Local Date)}$$'Median of all Datesdate-inputWHERE "Local Date">= '$${Sdate-input}$$'FlowVariablesDB Table Remover Test Data Generator prepare_data Column Rename PostgreSQLConnector DB Table Creator DB Insert Random NumberAssigner Round Double Math Formula Date&Time Shift Column Filter GroupBy DB Query Table Rowto Variable Date&TimeConfiguration DB Query DB Reader DB Reader DB Row Filter DB 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: m_lauber
Created at: 2022-05-10
On NodePit since: 2022-05-11
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: sqlpostgrespostgresql

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

Try NodePit Runner!