Currently viewing the tag: "localtime"

How to convert UNIX datetime value to date/time string in OpenOffice Calc or Excel

By On 1 April 2013 · 1 Comment

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> […]

Continue Reading →

Linux clock shows invalid time (UTC vs Localtime problem)

By On 20 September 2011 · Leave a Comment

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!) […]

Continue Reading →
Set your Twitter account name in your settings to use the TwitterBar Section.