Timezone of creation date for docx file

[DimaKompot]

Let’s say I’m in CET timezone, 15:00 local time. I create new Writer document and save it as .docx (2007-365).
Then I open it as archive and go to:

docProps > core.xml

there I can see:

<dcterms:created xsi:type="dcterms:W3CDTF">2020-07-06T15:00:00Z</dcterms:created>

but this is wrong, since the date has Z on the end it means that this is UTC timestamp.
it should be like this:

<dcterms:created xsi:type="dcterms:W3CDTF">2020-07-06T13:00:00Z</dcterms:created>

or just timezone naive:

<dcterms:created xsi:type="dcterms:W3CDTF">2020-07-06T15:00:00</dcterms:created>

because of this some libraries, as python-docx, may have issues with timezones.

same goes for the review comments: LibreOffice saves it as local time, but adds UTC ‘Z’ to the timestamp.

Microsoft Office works differently and just put timestamps in the naive way inside (for comments) or in proper timezone (for creation date)

[ve3oat]

Does the same thing happen with documents that you save in other formats, such as .odt, .ods etc ?

[mikekaganski]

Yes, this is implemented in oox::core::writeElement. As you see,
the Z is hardcoded. The datetimes passed to it (see lines 647 and 657) are local times. You are welcome to file a bug report.