I use node-red-node-mysql 3.0.0 in my nodered instance v4.1.0 to exchanged data with my cluster Gallera 4.
I need to perform a select query on a table to extract the previous day's data.
But i have an inconsistency with the DataTime field.
My SQL query :
SELECT ID, Power, DateTime FROM VRM.HOME WHERE DateTime BETWEEN '2026-2-26 00:00:00' AND '2026-2-26 23:59:59'
It seems that there is some other node between your mysql node and debug 23, because we don't see ID or Power but we do see a date string, which represents Fevrier as 2 not 02
And then from debug 23 again we see the first element of an array with 53690 elements.
Here we see DateTime as
Note the T and the Z
This suggests to me that the database (as it should) stores timestamps as Zulu time also known as UTC.
Your query
seems to be interpreted as local time, presumably CET
2026-02-25 23:00:01 UTC is the same time as 2026-02-26 00:00:01 CET.
Your last screen capture is of PhpMyAdmin? I have no idea how this tool handles timezones, but it seems to be showing DateTime in CET.
You probably need to verify that the database stores timestamps as UTC and express your query parameters as UTC.
