linux-pages.com
... arcane linux knowledge collected over the eons, bit by bit ...
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> […]