Show Linux datetime

Discuss the spreadsheet application

Show Linux datetime

Postby kkaal » Wed Jan 16, 2008 7:24 pm

Hi,

I get from a database a UNIX timestamp, which I need to display in Calc correctly. Whatever I try, I get a wrong reading.

Has anybody ideas how to do that?

Thank you for any help
Klaus
kkaal
 
Posts: 2
Joined: Thu Dec 06, 2007 11:17 am

Re: Show Linux datetime

Postby Villeroy » Wed Jan 16, 2008 7:51 pm

Seconds since 1970-01-01? A day has 86400 seconds. Dates in Calc are numbers representing days since 1899-12-30.
=A1/86400+DATE(1970;1;1) and format the number as date/time
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Show Linux datetime

Postby huw » Thu Jan 17, 2008 11:49 am

See: [Solved] Timestamp conversion for a previous discussion and solutions.
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 34 guests