Postgres node not properly working with date comparison

[Jamminroot]

Bug Description

Operator in entry 1 of 'Select Rows' works with numbers, but value 2025-04-28 is not a number

To Reproduce

https://github.com/n8n-io/n8n/blob/d2178a13b17ac3c63e402c2a995de155b0fa9eb8/packages/nodes-base/nodes/Postgres/v2/helpers/utils.ts#L159

PostgreSQL type is TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP (timestamp with time zone)

Expected behavior

Change condition

Operating System

123

n8n Version

123

Node.js Version

123

Database

SQLite (default)

Execution mode

main (default)

[Joffcom]

Hey @Jamminroot,

We have created an internal ticket to look into this which we will be tracking as "GHC-1780"

[Joffcom]

Thank you for bringing this up! It looks like this issue is a duplicate of #14971 , where we’re already tracking progress and updates. To keep things organized, we’ll close this issue and continue the discussion over there.

If you have any additional details or context that might help, please feel free to add them to the original issue. Your input is always appreciated!

Thanks again for your contribution, and let us know if there’s anything else we can assist with.

[unclesp1d3r]

Thank you for bringing this up! It looks like this issue is a duplicate of #14971 , where we’re already tracking progress and updates. To keep things organized, we’ll close this issue and continue the discussion over there.

If you have any additional details or context that might help, please feel free to add them to the original issue. Your input is always appreciated!

Thanks again for your contribution, and let us know if there’s anything else we can assist with.

Can you share any updates there because the silence just looks like it is being ignored, so this is good feedback.