How do I convert Epoch time to a Date?

[amit_kothari]

What is Epoch time and how do I make it readable in my insight?

[amit_kothari · Accepted solution]

The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds. (More info at https://www.epochconverter.com/)

You can use the following formula:

addSeconds(date('1970-01-01'), [Insert EPOCH field here]/1000)