I have date like this datetime = "2021-10-18T13:20:51.404Z" I want like this "2021-10-18 13:20:51" for mysql database and array = [20,30,40,50,60,70,40,30]; datetime is for array[0] (20) I want something like this o= { array[0] : datetime, array[1] : datetime + 30min, array[2]: datetime +30…

Date to mysql datetime

E1cid 18 October 2021 20:22 6

In my example it is in msg.date_time. msg.payload is already an array.
You do not need to use msg.payload you are free to use any other msg property you wish.

1 Like

Topic		Replies	Views
How to get date time to mysql General	11	3827	8 February 2021
Guess this is java related: datetime General database	11	243	7 January 2023
Convert datetime with moment General	11	3703	10 July 2019
How do I convert MySQL TIMESTAMP to UK date/time format? General	3	240	10 January 2023
Convert format of datetime from database to local time with Moment node Dashboard	6	3911	17 June 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.

Date to mysql datetime

Related topics