To convert a UNIX datetime value to date/time string in OpenOffice Calc or Excel use this formula (assumes your datetime stamp is in the A1 cell of the current spreadsheet):

=A1/86400+DATEVALUE(“1/1/1970”)

If you want to test the above you may use the following simple C program:
=======

#include <stdio.h> #include <stdlib.h> […]