Converting from a UNIX Timestamp
A Unix timestamp can be converted in Paxata using a Compute statement.
The steps for converting from Unix timestamp to Gregorian date are as follows:
- Click on the Compute icon in the left-hand Tools bar.
- Give your new column a name, such as “Transaction Date”
- Enter this formula:
Dateadd(Datevalue("1970-01-01", "yyyy-MM-dd"), @Unix Time Stamp@, "seconds")
(replace @Unix Time Stamp@ with your actual column name)
- Click Save.
Not familiar with Unix timestamp format?
The Unix timestamp format is the number of seconds since epoch, which is Thursday, Jan 1, 1970 00:00:00 UTC. For example, May, 17, 2017, 2:29:14 PM Pacific, in a Unix timestamp format is 1495056554