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]

Hi, welcome to the forum! Are you wanting to create a timestamp from scratch, for example the time now, or... ...do you have a timestamp already whose format needs changing to dd.hh.mm.ss?

If you want to store the current time in the database then specify the column to be of type TIMESTAMP and set it to DEFAULT CURRENT_TIMESTAMP and when you add a record do not provide a timestamp value, then it will automatically be set to the current time.

Hello Paul. I have the date in a way, as you can see in the picture, and I want to change it to a value that is in hh.mm.ss. [3]

Hello colin. But i change here in the node template? [4]

You did not make it clear that it is displaying the timestamp that is the problem. I thought you meant that you wanted to get the timestamp into the database.

Well, this I already have, I want is that instead of presenting the values, for example 1605613000818 present in the dd.hh.mm.ss. Is that possible?

Okay, I'll try it and then I'll say something.

I did this, but I'm in doubt, if this is correct. [5]

What relationship does that have to the example I linked to? There doesn't seem to be a JSON node in the example. Did you import the example and see how it works?

Node-RED

Node-RED Forum

Date formatting

Dashboard

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

Topic		Replies	Views
Timestamp to SQL Server in Node Red Dashboard database	2	397	6 October 2023
Converting UNIX format to normal human format General	2	1603	6 April 2021
[newbie] changing a date time format General	6	515	20 September 2020
How to create a timestamp in the right format for a dashboard chart General node-red-dashboard , function-node	11	18951	18 January 2022
Change Time Format string value General	10	3102	21 September 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 formatting

Related topics