Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-09-2022 01:49 PM
What is Epoch time and how do I make it readable in my insight?
Solved! Go to Solution.
Labels:
- Labels:
-
Formulas
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
