LibreOffice 24.2 Community released

Posted Feb 3, 2024 8:37 UTC (Sat) by Wol (subscriber, #4433)
In reply to: LibreOffice 24.2 Community released by atnot
Parent article: LibreOffice 24.2 Community released

From what I can make out from the summary I read (by someone who's name I recognise, so I trust it), the gist of the standard is you start with the most significant digit (currently 2 for the second millenium) and mustn't leave anything out. Apart from year, everything is two-digit.

So 20240 is actually valid, and unambiguously means any time this year before 1st Nov. Plus the standard delimiters are - and :, if you want UTC you should put T between the date and time, and if there's no indication you assume local time. (You can use Z instead of T, but technically that means the obsolete GMT, which is not quite the same as UTC.)

So it's pretty sensible.

Cheers,
Wol

to post comments

LibreOffice 24.2 Community released

Posted Feb 3, 2024 16:46 UTC (Sat) by smcv (subscriber, #53363) [Link]

The T and the Z in RFC3339 aren't at the same position in the date/time string, so I think there's some misunderstanding here about their roles, either in the summary you've read or in your interpretation of it.

The example given in RFC3339 is "1985-04-12T23:20:50.52Z", where T is a separator between date and time (nothing to do with time zones, just another separator like : and -), and Z is a shorthand for +00:00, denoting no offset from UTC (and it's UTC not GMT, at least according to the RFC text).

My understanding of ISO 8601 is that its way to write "12th April 1985 at 23:20:50.52 in a time zone I am not specifying here" is to remove the time zone designator entirely, like "1985-04-12T23:20:50.52". RFC3339 specifically doesn't allow an unspecified time zone, though.

The Z is borrowed from an older military standard where times are suffixed with a single letter representing the time zone (spoken using the NATO phonetic alphabet, hence "Zulu time" for UTC), but in RFC3339 the only time zone where this shorthand is allowed is Z, and all the others need to be spelled out as +05:00 or similar (so in particular T is not a valid timezone suffix in RFC3339). As far as I know, the same is true for ISO 8601.