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] Lupin_III: While in Debian I get the wrong one, that means "2022-06-09T07:00:00.000Z" which is supposed to be in UTC but it actually is my local times. Infact it is the same as it is shown in the GUI: 2022-06-07 09:00:00 That would commonly be because the Debian system timezone is not…

as @nodeautomata says, the problem is that from CLI you see the timestamp in locl time 2022-08-03 18:32:42 while in node-red, within debug node, you see it in UTC time 2022-08-03T18:31:17.000Z

OK. following you're suggestion I've made some other test and searching. In mysql, if you save a date like "2022-08-03 15:23:50" in a column of type "timestamp", it should automatically convert and store it in UTC time. This as least as defoult behaviour if you don'e make any particular settings ch…

Yes, that indicates that your server is set to UTC not local. That is fine but just needs to be remembered. The general recommendation is to always work in UTC for managing timestamps and only convert from/to local at point of user interaction.

But I still don't understand why the date is not correct and how I can solve it. Which settings I need to adjust. On windows I have the same settings in C:\xampp\mysql\bin\my.ini and everything works as expected

Are you accessing the same database or is the database also on both systems?

Each OS has it's own database. The databases are not shared between them. The local machine stores data locally and send it on the remote server, where are stored in its DB

In that case it could be that the databases contain different timestamps.

I imagine, for this I posted the check I made. It seems to be the same. On both mysql |@@global.time_zone|@@session.time_zone I get +00:00 | +00:00

Mysql: different date Debian VS Windows

General

TotallyInformation 4 August 2022 12:13 12

I don't know for sure but you need to look at the differences. If a command line listing of the current time is different on the two systems, that's where you need to look first. Windows will normally automatically adjust to your locality from the install settings. Linux may not always do that but there is a tz (?) app that lets you change the server's timezone.

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