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> #include <string.h> #include <time.h> […]
localtime
Linux clock shows invalid time (UTC vs Localtime problem)
In a Linux multi-boot system it often happens that one distro shows correct system time and another does not. The problem is in how the startup scripts interpret the hardware (BIOS) clock when setting the OS time (the so called System Clock). If you want to learn more about this (and fix this problem PROPERLY!) […]