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.


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