Why does node-red convert time to utc. I have records in a mysql data that is stored in local time. When you execute the stored procedure from phpMyAdmin, the datetime field is correct, but for some reason the mysql connector appears to return the datatime in UTC. I've set the timezone on the pi …

Answered my own question: var tz_offset = (new Date()).getTimezoneOffset() * 60 * 1000 let r = msg.payload[0]; let data = [r.map( v => ({ "dtStart": new Date(v.dtStart.getTime() - tz_offset), "dtEnd" : new Date(v.End.getTime() - tz_offset), }))]; msg.payload = data; return msg;

Node-Red uses UTC

General

TotallyInformation 10 November 2018 00:36 5

The default for storing and processing date/time values should always be UTC. That's to avoid timezone and DST processing errors. You should generally only ever convert to local time on display. If you don't do this, you have to be very careful about each step of your processing, storage and display.

Trouble with UTC and lighting automation

Topic		Replies	Views
Still confused over Node-Red/Mariadb Datetime General	3	498	28 June 2021
Localtime instead of UTC General	3	462	30 January 2022
Timestamp and GMT value problem General node-red-dashboard , database , function-node	7	428	12 August 2022
MYSQL Time from Record different General	6	431	25 July 2022
Sql query of Datetime column returning UTC time not the table data General	11	261	9 December 2022

Node-Red uses UTC

Related Topics