Carl Boettiger created ARROW-18214: -------------------------------------- Summary: [R] Use ISO 8601 in character representations of datetimes? Key: ARROW-18214 URL: https://issues.apache.org/jira/browse/ARROW-18214 Project: Apache Arrow Issue Type: Bug Reporter: Carl Boettiger
Arrow needs to represent datetime / timestamp values as character strings, e.g. when writing to CSV or when generating partitions on timestamp-valued column. When this occurs, Arrow generates a string such as: "2022-11-01 21:12:46.771925+0000" In particular, this uses a space instead of a T between the date and time components. I believe either is permitted in [RFC 3339|https://www.rfc-editor.org/rfc/rfc3339.html#section-5] ??5.6. NOTE: ISO 8601 defines date and time separated by "T". Applications using this syntax may choose, for the sake of readability, to specify a full-date and full-time separated by (say) a space character.?? But as RFC 3339 notes, this is not valid under ISO 8601. It would be preferable to stick to the stricter ISO 8601 convention. This would be more consistent with other software. -- This message was sent by Atlassian Jira (v8.20.10#820010)