Node-Red uses UTC

[TotallyInformation]

@DerekG007

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.

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.