Convert OpenWeather epoch time

General
1

From OpenWeatherMap I get the sunrise ("payload.sunrise") but it is in epoch format (see image). I am unable to program the function node to display the time in human readable format and I have also not been able to do so with the information on this forum.

Can someone help me with the correct code for that function

NR
NR1248Ă—741 56.9 KB

node?

2

Hi @HaVi

Using a change node, you can format out the dates for your objects using JSONata.

image
image804Ă—412 10.4 KB

$fromMillis(payload.sunrise*1000,'[Y0001]-[M01]-[D01] [H01]:[m01]:00')

Add a line for each of your date timestamps in the change node

Or if you prefer the Function node approch.

let d = new Date(0);
d.setUTCSeconds(msg.payload.sunrise);
msg.payload.sunrise = d
3

Thanks for helping Marcus, I chose the function node and it works perfectly!

4

I use this: node-red-contrib-moment (node) - Node-RED

5

I also wanted to chime in with the moment node. It's one of the first nodes I install on every new install of node-red, if not the first.

6

I did once use moment, but it can only process 1 property at a time (unless I'm mistaken)
So if you have multiple in 1 payload, it will become cumbersome to use.

The op seems to have 2, using the change node is much easier for situations like this.
Or maybe @TotallyInformation can develop a new one, that can process multiple properties using the more modern lib Day.js :wink:

7

i did not know this. I have only tried it one one value at a time

8

Nice to know! Though I'll be the first to admit that it hasn't had any TLC in a long time. Gets the job done though. Really needs replacing with something that uses a more current library since Moment isn't being developed any more. I just don't have time to do it.

Yes, it does, though I guess you could run your data through more than one :grin:

True.

I would love to have the time. Sadly, I don't. Still if someone did have the time, I'd be more than happy to let them loose on the repo and I'd even help :wink: Probably best to have a new node in the package so that people weren't disrupted by the change.

9

Also a nice node to use, thanks for pointing it out. It's good to see how much support there is on the forum!