Show Linux datetime

Discuss the spreadsheet application

Show Linux datetime

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


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
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
Posts: 28844
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.
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

Return to Calc

Who is online

Users browsing this forum: No registered users and 28 guests