Convert UNIX time

Good afternoon
Does anyone know how to convert a time in unix format to standar hour:minutes
"sunrise: "1619328353
"sunrise: "hh:mm

Hi, check out the FORMAT_DATETIME_LOCAL formula → docs

1 Like

Doesnt seem to be working for a unix timestamp.

If I use this formala on this timestamp: 1619769600 it comes back wrong (without the specific date, only the time changes and the date stays 1970).

What am I doing wrong?

Hi, the formula function takes the time in milliseconds so you’ll need to multiply your value by 1000 to get the right results.

2 Likes

Thanks! This is the solution.

Yea I was going to say if you were comfortable with Javascript you could do this:

var date = new Date(unix_timestamp * 1000);

1 Like