Converting mysql date formats for excel

[marjorie]

OK, so Ive exported the members table from the mysql databse.

What is the format of the lastlogin datefield, or to be more precise, howcan I convert 1397656420 into d//m/y in Excel?

[vbgamer45]

It is a unix timestamp

Convert via SQL
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime

[marjorie]

Thanks - time to strap on my SQL cojones!