Unix epoch time is a system for describing instants in time. It is shown in the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, January 1, 1970. It is commonly used with servers and databases, though sometimes software is in place to convert it to a standard format.
If a metric returns points in time in unix epoch time, it will likely show up in seconds. You can use easy SQLite functions called "date" and "datetime" to change it into a more relevant date and time. Here’s how:
With a SQL transform, use the following code:
DATE(`columnName`, 'unixepoch') as `Date`
This will turn it into a normal date field. If you want the field to include the hours and minutes as well, use the
datetime(`columnName`, ‘unixepoch’) as Date command instead.
Note: Some APIs will return the number of milliseconds, not seconds. (You can tell based on the length of the string. 13 characters = milliseconds; 10 characters = seconds.) If this is the case, use the string
date(columnName/1000, ‘unixepoch’) as Date . This will convert the value into milliseconds and allow SQLite to interpret the date correctly.