I have a Mariadb table (server is my Raspberry Pi in the UK, system time is default, currently BST) create table foo (created datetime default now(), mydate datetime); and Node-Red creates a record via the mysql node. var date1 = new Date().toISOString().slice(0, 19).replace('T', ' '); msg.to…

jbudd 13 June 2021 21:39 2

I have found a way to set the database timezone to UTC:
/etc/mysql/mariadb.conf.d/50-server.cnf insert immediately below [server]:
default-time-zone=+00:00

2 Likes

Topic		Replies	Views
Node-Red uses UTC General	3	2531	10 November 2018
Yet another SQL timestamp doubt General database , mysql , time	17	185	30 December 2024
Using the time in node red General	21	12128	7 April 2021
Cannot create mysql tables with respect to date in my time zone General	2	988	8 December 2019
Mysql: different date Debian VS Windows General	37	412	19 August 2022

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.

Still confused over Node-Red/Mariadb Datetime

Related topics