Hi, I'm facing this problem without succeeding. I have a project running on both Windows and Debian system. As database I use phpmyadmin, and in node-red this mysql node node-red-node-mysql (node) - Node-RED . The problem is that node-red returns two different value, depending on the system it's r…

DONE. Thanks so much. Looking at windows log I noticed that message. The problem was within the mysql config node. On debian I had "2", on windows nothing.

[image] Colin: I have lost track of what the problem is now. I get two different result in node-red on Windows and Debian OS, while in phpmyadmin CLI I get the same one [image] Colin: What timezone setting have you got on each machine? these are the settings (on both OS date.timezone …

Doing some more check in time settings differences, I haven't been able to make this one identical Window's phpmyadmin GUI [image] Debian's phpmyadmin GUI [image] But at the end CEST and Europe/Berline should be the same. I remind you that Debian is a virtual server in Germany, Windows is a loc…

In the debian system what does this command show date In the windows system what do you see for the timezone in the system Date and Time settings? If you run this flow on each machine what do you see in the debug node? [{"id":"0cd26f71a04019c2","type":"inject","z":"bdd7be38.d3b55","name":"","pro…

[image] Colin: In the debian system what does this command show date [image] [image] Colin: In the windows system what do you see for the timezone in the system Date and Time settings? [image] [image] Colin: If you run this flow on each machine what do you see in the debug node…

Is it possible that when the date/time was inserted into mysql, the timezone was different? " MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such as DATETIME .) By default,…

[image] Colin: Your Debian system is on CEST which is UTC+2, but the Windows machine is set to UTC+1 No, because it is enabled summer time. And if so we should have 1 hour as difference betwheen the result

I even thought this, but I've just made a test with a new data manually inserted, and nothing change. The behavior on both system doesn't change. Result is correctly shown in phpmyadmin but not in node-red

[image] Lupin_III: No, because it is enabled summer time. Yes, you are right.

On the Debian system, with the timestamp flow I posted, change the debug node to also output to the system console and see what you get in the node-red log.

Mysql: different date Debian VS Windows

General

Colin 5 August 2022 10:00 23

Your Debian system is on CEST which is UTC+2, but the Windows machine is set to UTC+1.

Where were you running the browser when you ran the flows? I meant you to run the browser on the machine running node-red, though I did not say that.

Topic		Replies	Views
Yet another SQL timestamp doubt General database , mysql , time	17	286	30 December 2024
MYSQL Time from Record different General	6	541	25 July 2022
Node-red and mySQL show different output General	8	1336	23 December 2019
Coordinated Universal Time to Z time General	35	2139	14 April 2021
Mysql node : inconsistent data General function-node	1	44	27 February 2026

Mysql: different date Debian VS Windows

Related topics