Hello guys. I'm new to the red node and needed some help. I created the two flows below and created a table in the red node with SQLite to store my values away and I can't format the timestamp for a value with dd.hh.mm.ss. Can someone give me a hand? [1] [2]

Date formatting

E1cid 17 November 2020 16:56 14

Here is another example of converting timestamps in an array to "YYYY-MM-DD HH:mm" format.
convert timestamps in array

Topic		Replies	Views
Timestamp to SQL Server in Node Red Dashboard database	3	302	5 November 2023
How to convert time format in this node General function-node	7	376	3 May 2022
How to create a timestamp in the right format for a dashboard chart General node-red-dashboard , function-node	12	12528	1 February 2022
"Error: You have an error in your SQL syntax; General	7	237	14 February 2023
Yet another SQL timestamp doubt General database , mysql , time	16	94	1 October 2024

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 formatting

Related Topics