Utc number to time

[vikozo]

hello

i call up a page and i got a objekt back

payload.passes[0].startUTC: 1624496900

in the node red debug it is possible to click a cuple of time to get
24.6.2021, 03:08:20 [UTC+2]

but just to send this to telgram i still have the number how to change it to a time +2h for central Europe?

have a nice day
vinc

[ScheepersJohan]

let targetTime = msg.payload.passes[0].startUTC;
let offset = 2;
let tzDifference = offset * 60 + targetTime.getTimezoneOffset();
let time = new Date(targetTime.getTime() + tzDifference * 60 * 1000);

[vikozo]

@ScheepersJohan
thanks for the fast feedback

the function node get the error

function : (error)
"TypeError: targetTime.getTimezoneOffset is not a function"

but will digg for it later

[Trying_to_learn]

Here is a little subflow I wrote to give you a time stamp.
There are 3 outputs.
1 - for use in log files so you can read it.
2 - the time is in msg.time and can be used downstream by other nodes.
3 - used if you want to create file names with the date.

Just an offering.

[{"id":"5a81f3be.561bdc","type":"subflow","name":"Time Stamp","info":"**3 outputs.  1 - msg.payload holds the time. 2 - msg.time holds the time in a way to be used for reading time in a log file. 3 - outputs nsg.time in a format usable for file names**","category":"","in":[{"x":80,"y":100,"wires":[{"id":"682ac304.0590d4"}]}],"out":[{"x":640,"y":180,"wires":[{"id":"cf554e88.9fff18","port":0},{"id":"682ac304.0590d4","port":0}]},{"x":640,"y":230,"wires":[{"id":"682ac304.0590d4","port":0},{"id":"3db4df41.634848","port":0}]},{"x":640,"y":280,"wires":[{"id":"e4ca4227.3109c8","port":0},{"id":"682ac304.0590d4","port":0}]}],"env":[],"color":"#FF8888","outputLabels":["For use in log files","msg.time","For filename use"],"icon":"node-red/timer.svg"},{"id":"cf554e88.9fff18","type":"moment","z":"5a81f3be.561bdc","name":"","topic":"","input":"payload","inputType":"msg","inTz":"Australia/Sydney","adjAmount":0,"adjType":"days","adjDir":"add","format":"YYYY-MM-DD HH:mm:ss","locale":"en_AU","output":"payload","outputType":"msg","outTz":"Australia/Sydney","x":390,"y":180,"wires":[["e4ca4227.3109c8","c810aa73.a5706"]]},{"id":"e4ca4227.3109c8","type":"string","z":"5a81f3be.561bdc","name":"","methods":[{"name":"replaceAll","params":[{"type":"str","value":":"},{"type":"str","value":""}]}],"prop":"payload","propout":"payload","object":"msg","objectout":"msg","x":440,"y":280,"wires":[[]]},{"id":"c810aa73.a5706","type":"change","z":"5a81f3be.561bdc","name":"TOPIC","rules":[{"t":"move","p":"payload","pt":"msg","to":"time","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":220,"y":230,"wires":[["3db4df41.634848"]]},{"id":"be4fd533.c9abb","type":"change","z":"5a81f3be.561bdc","name":"Save","rules":[{"t":"set","p":"payload","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":220,"y":140,"wires":[["c7ad4b3c.3a5368"]]},{"id":"3db4df41.634848","type":"change","z":"5a81f3be.561bdc","name":"Get","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":440,"y":230,"wires":[[]]},{"id":"682ac304.0590d4","type":"switch","z":"5a81f3be.561bdc","name":"check topic","property":"topic","propertyType":"msg","rules":[{"t":"eq","v":"TIMESTAMP","vt":"str"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":200,"y":100,"wires":[[],["be4fd533.c9abb"]]},{"id":"c7ad4b3c.3a5368","type":"change","z":"5a81f3be.561bdc","name":"TimeStamp","rules":[{"t":"set","p":"payload","pt":"msg","to":"","tot":"date"}],"action":"","property":"","from":"","to":"","reg":false,"x":200,"y":180,"wires":[["cf554e88.9fff18"]]},{"id":"537c4cf1.68c114","type":"subflow:5a81f3be.561bdc","z":"e43e3902.57c4e8","name":"","x":770,"y":760,"wires":[["352be3cd.915574"],[],[]]}]

[E1cid]

This can be done in the change node with a JSONata expression and $moment()

[{"id":"4749bb34.e9d6f4","type":"inject","z":"c74669a0.6a34f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"1624496900","payloadType":"num","x":240,"y":1500,"wires":[["ca7013e5.c256"]]},{"id":"ca7013e5.c256","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload*1000).tz(\"CET\").format(\"DD.MM.YYYY, HH:mm:ss Z\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":450,"y":1500,"wires":[["ef68f5ed.f012a"]]},{"id":"ef68f5ed.f012a","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":670,"y":1540,"wires":[]}]

$moment(payload*1000).tz("CET").format("DD.MM.YYYY, HH:mm:ss Z")

*1000 as unix time is in seconds and JSONata uses milliseconds like Javascript

[vikozo]

@E1cid
works fine your 3 node
i added to my function node an defined as a variable,
like
var (or let) test2 = $moment(msg.payload.passes[0].maxUTC*1000).tz("CET").format("DD.MM.YYYY, HH:mm:ss Z");

which did not work ;-(

[E1cid]

@E1cid

in the change node with a JSONata expression and $moment()

It is JSONata not Javascript. It will not work in a function node.

[vikozo]

so i will have to split and join
merci @E1cid

[vikozo]

this would work too
let start = new Date(msg.payload.passes[0].startUTC*1000);

but have to find out about formatin it

[vikozo]

function aLZ(n){
  if(n <= 9){
    return "0" + n;
  }
  return n
}

let startUTC = new Date(msg.payload.passes[0].startUTC*1000);
let Year    = startUTC.getFullYear();
let Month   = aLZ(startUTC.getMonth());
let Date2   = aLZ(startUTC.getDate());
let hours   = aLZ(startUTC.getHours());
let minutes = aLZ(startUTC.getMinutes());
let seconds = aLZ(startUTC.getSeconds());

+"\r\n" +Date2 +"." +Month +"." +Year +"|" +hours +":"+minutes +":" +seconds

the aLZ is appendLeadingZeroes
the line starting with +"\r\n" is insyde the message to send

found it there How To Format Date In JavaScript | CodeHandbook

[Colin]

@vikozo

let Month = aLZ(startUTC.getMonth());

You don't need your aLZ() function, you can use
let Month = startUTC.getMonth().toString().padStart(2,"0")
In fact for month I would have thought you wanted
let Month = (startUTC.getMonth() + 1).toString().padStart(2,"0")

It would also be marginally better to use const month = rather than let for all the variables which tells the interpreter that they will not change and may result in slightly more efficient code.

[vikozo]

Merci @Colin
fun to see how many ways at the end are there.
But what is the difference and when to use it (var, let or const)?

[Colin]

@vikozo

what is the difference and when to use it (var, let or const)?

Google found this explanation for me Var, Let, and Const – What's the Difference?