Convert UNIX time

[CARLOS_ALVAREZ]

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

[Mari]

Hi, check out the FORMAT_DATETIME_LOCAL formula → docs

[Bas_24]

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?

[Mari]

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

[Bas_24]

Thanks! This is the solution.

[JOHN_WORSHAM]

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

var date = new Date(unix_timestamp * 1000);