Results 1 to 4 of 4

Thread: LibreOffice internal date format

  1. #1
    Join Date
    Aug 2013
    Beans
    34

    LibreOffice internal date format

    Hi,
    I unzipped an .ods file and the meta.xml file has this:
    Code:
    <meta:creation-date>2013-12-18T21:08:47.079646992</meta:creation-date>
    <dc:date>2014-01-08T08:40:11.689560849</dc:date>
    Any idea what the .079646992 and .689560849 stand for?

    PS: In case it matters, I'm trying to create a C++ reader/writer of .ods (spreadsheet) files.

  2. #2
    Join Date
    Aug 2011
    Location
    47°9′S 126°43W
    Beans
    2,172
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: LibreOffice internal date format

    Nanoseconds, very likely (that makes 47.079646992 and 11.689560849 fractional seconds).
    Warning: unless noted otherwise, code in my posts should be understood as "coding suggestions", and its use may require more neurones than the two necessary for Ctrl-C/Ctrl-V.

  3. #3
    Join Date
    Aug 2013
    Beans
    34

    Re: LibreOffice internal date format

    Wow, you're clever, thanks. It didn't cross my mind cause I thought nanoseconds make no sense in timing a document, apparently they do matter.

  4. #4
    Join Date
    Jul 2007
    Location
    Poland
    Beans
    4,499
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: LibreOffice internal date format

    they don't matter from the user perspective but the internal representation of timestamps in the system has such precision, why bother truncating it if it doesn't matter?
    if your question is answered, mark the thread as [SOLVED]. Thx.
    To post code or command output, use [code] tags.
    Check your bash script here // BashFAQ // BashPitfalls

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •