Converting from a UNIX Timestamp

August 30, 2017

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:

  1. Click on the Compute icon in the left-hand Tools bar.
  2. Give your new column a name, such as “Transaction Date”
  3. Enter this formula:
    Dateadd(Datevalue("1970-01-01", "yyyy-MM-dd"), @Unix Time Stamp@, "seconds")
                   (replace @Unix Time Stamp@ with your actual column name)
  4. 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

 

Show Buttons
Hide Buttons