Hello, I am building an IoT project. I need timing query from Timestamp. Ex: Timestamp -> 1618809944697 So, how can i separate this Timestamp into year, month, day, hour, ... help me please.

[image] Get time matching ui_date_picker General I use node-red-contrib-moment here is an example.... [Screenshot from 2021-03-13 21-50-27] [{"id":"38408627.2b4cda","type":"moment","z":"150b582b.3e6d68","name":"year","topic":"","input":"epoch","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"YYYY","locale":"C","output":"year","outputType":"msg","outTz":"America/New_York","x":330,"y":860,"wires":[["16c64f42.d8cb39"]]},{"id":"16c64f42.d8cb39","type":"moment","z":"150b582b.3e6d68","name":"mon…

I prefer to use moments and JSONata to play with time , I just find it easier than JS. So I would convert the time stamp, split the string and then convert to numbers. Here is an example using a change node and JSONata and moments. [{"id":"a80dbfdf.997f18","type":"inject","z":"5a245aa1.510164","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":920,"wires":[["8315a549.29ab2"]]},{"id":"8315a549.29ab2","type":"change","z":"5a245aa1.510164","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"($dateparts := $split($moment(payload).tz(\"Europe/London\").format(\"YYYY-M-D-H-m-s\"),\"-\");\t$names := [\"year\",\"month\",\"day\",\"hours\",\"minutes\",\"seconds\"];\t$merge($map($dateparts, function($v,$i){{$names[$i]:$number($v)}}))\t)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":390,"y":920,"wires":[["cbd69445.e1aaa8"]]},{"id":"cbd69445.e1aaa8","type":"debug","z":"5a245aa1.510164","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":640,"y":920,"wires":[]}] ( $dateparts := $split( $moment(payload).tz("Europe/London").format("YYYY-M-D-H-m-s"), "-" ); $names := [ "year", "month", "day", "hours", "minutes", "seconds" ]; $merge( $map( $dateparts, function($v,$i){{$names[$i]:$number($v)}} ) ) ) output {"year":2021,"month":4,"day":19,"hours":8,"minutes":10,"seconds":12}

Node-RED

Node-RED Forum

Separate timestamp

General

meeki007 19 April 2021 06:50 2

Topic		Replies	Views
How to split up a message General	6	778	18 November 2020
Timestamp ms to HH:MM:SS General	4	2503	15 January 2020
Separate time stamp and payload from string General	3	1465	17 January 2020
How to get array using split node? General	8	1284	16 November 2020
Timestamp in function problems General	11	3018	22 October 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.

Separate timestamp

Related topics