XF 2.2 How to translate dates in database tables

[sdchan]

I am looking at a csv file of user upgrades from the xf_user table and I'm not understanding the date formats contained - how do I translate these into actual dates? See screenshot below:

 

[digitalpoint]

They are unix timestamps (the number of seconds since Jan 1, 1970 UTC.

Some info:

Unix Time Stamp - Epoch Converter

Epoch and unix timestamp converter for developers. Date and time function syntax reference for various programming languages.

www.unixtimestamp.com

And some info for converting them to human readable dates in Excel:

Excel formula: Convert Unix time stamp to Excel date | Exceljet

The Unix time stamp tracks time as a running count of seconds. The count begins at the "Unix Epoch" on January 1st, 1970, so a Unix time stamp is simply the total seconds between any given date and the Unix Epoch.

exceljet.net

 

[Miri]

I confirm the one written by @digitalpoint, however I wanted to add another equally useful service, with the possibility of performing batch conversions. you can also do reverse conversions

Epoch Batch Conversion Tool

www.epochconverter.com