03-09-2022 01:49 PM
What is Epoch time and how do I make it readable in my insight?
Solved! Go to Solution.
03-09-2022 01:51 PM - edited 07-19-2023 08:50 AM
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)