MySQL Node - Select -> 'Select Rows' works with numbers

[Manuel]

I need help - I cannot figure out how to use the MySQL node “Select” and filter for a date. If I am using custom query it obviously works - but I am trying to understand what I am doing wrong by using the normal “Select” Method provided by the node.

Describe the problem/error/question

If I select my table and enter a column filter - it says it needs a number.

What is the error message (if any)?

“Operator in entry 1 of ‘Select Rows’ works with numbers, but value 2024-05-07 is not a number”

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.38.1
• Database (default: SQLite): default
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): docker
• Operating system: linux

[barn4k]

Hello @Manuel
I don’t have a mysql db, but there might be a couple of options:
Try to set date in the format YYYYMMDD (e.g. 20240506)
Or set it as a timestamp (e.g. 1715194449000)

[aya]

I don’t think there’s a way to compare non-numeric values with the current MySQL node (although it would be nice to be able to do that, could be a feature request!). It would be the easiest to use custom query for this for now

[Manuel]

Thanks for your suggestion - I guess it would solve it, but does not really go with the data type in my DB (which is date). But interesting suggestion.

[Manuel]

Hello @aya,

thanks as well for your input! I just wanted to clarify if I am missunderstanding the node or intention of the mysql “select” feature.

I will mark you answer as “solution” → create a ticket in Feature Request and use custom query for now.