Hi Guys and Hello node red team, My query is in reference to the point that Julius @TotallyInformation mentioned = "Always store DB entries in UTC" in the article " Wrong Timezone data in sql query result?!? " I found that its two ways to achieve this: Client side conversion - (Doing conversion …

Do you have to use mysql? Timestamps in mysql can be a nightmare. If you are storing time series data then you could consider influxdb instead.

Yeah. I'll try it next. But my domain lies in IIOT. You can understand.

[image] shubhamnodered: But my domain lies in IIOT I think influxdb is very much in the IIOT domain.

You may be right but i haven't tried it yet. Heard about it LOT! - like High cardinality, data compression & more suited for times-series data. Will start on it with documention maybe from day after tomorrow. However, the issue that i raised above still remain unanswered. And i think, the issue li…

Have you checked the tz on your server(s)? Are they set to use UTC? By default, MySQL uses the servers system timezone settings. You can force it to use UTC though by adding this to the conf file and restarting the server: default_time_zone='+00:00' By using UTC for everything except user inputs a…

Hi Julius, As i already mentioned, i particular talked & discussing client side(node-red) UTC conversion [to avoid confusion] with server runing in local time [mentioned at foot note]. Though, i also tried server side UTC conversion as well by using "SET GLOBAL SYSTEM = '+00:00'" but result remain…

[image] shubhamnodered: "SET GLOBAL SYSTEM = '+00:00'" I'm not sure what command that is. I believe you need to issue these 2 commands if you don't want to change the conf file: SET @@global.time_zone='+00:00'; SET @@session.time_zone='+00:00'; If your server(s) are Linux, you can check the…

Sorry, My mistake. I typed wrong here in chat. What i used: SET GLOBAL time_zone = '+00:00'; Even though your discussion lies with UTC conversion taken care by server., problem still remains the same [image]

HI Juliu @TotallyInformation , , Waiting for your reply.

Didn't see a question in your last reply. Having set the global and session defaults, what is a datetime field now returning?

Node-RED

Node-RED Forum

Yet another SQL timestamp doubt

General

shubhamnodered 1 October 2024 06:56 14

HI @knolleary, @Steve-Mcl, @E1cid can anyone guide me with this one?

Mysql and daylight saving time

Topic		Replies	Views
MYSQL Time from Record different General	5	548	26 May 2022
Mysql: different date Debian VS Windows General	36	615	5 August 2022
Node-Red uses UTC General	3	2562	10 November 2018
Wrong Timezone data in sql query result?!? General	13	622	2 April 2022
Timestamp value change while insert and select from mariadb General	8	5326	11 July 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Yet another SQL timestamp doubt

Related topics