How to convert Milliseconds into Date

Vova

I have a data set with timestamp represented in milliseconds and I want to convert it into date .

Data sample: "1656076776827"

Expected after conversion: "24 June 2022 09:19:36"

I looked at the beastmode and could not find anything that would help me to convert it, any suggestions?

Godiepi

Hi @Vova

Try this, you might need to adjust the time depending of your time zone

FROM_UNIXTIME(1656076776827/1000,'%d %M %Y %H:%i:%s')