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

Colin 17 November 2020 13:58 8

Of course. This example from @E1cid shows an example of how to do it with jsonata in a change node. Converting DateTime to dd/mm/yyyy hh:mm

1 Like

Topic		Replies	Views
Timestamp to SQL Server in Node Red Dashboard database	3	236	5 November 2023
How to convert time format in this node General function-node	7	327	3 May 2022
How to create a timestamp in the right format for a dashboard chart General node-red-dashboard , function-node	12	7316	1 February 2022
"Error: You have an error in your SQL syntax; General	7	213	14 February 2023
Label of a table with data from the influxdb database General	5	197	8 January 2023

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