[MDEV-29564] please add Time format ISO 8601 to DATE_FORMAT Created: 2022-09-18  Updated: 2022-09-22

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.10.1
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Avi Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-10018 Timestamp with time zone Open

 Description   

It would be nice to be able to generate a timestamp that is fully ISO 8601 compliant, complete with correct formatting of milliseconds, that is able to include UTC offset, so that the string can be returned directly to Javascript without any additional string manipulation to render into the proper format.

such a timestamp might look like

2022-10-01T20:04:05.465+05:30


Generated at Thu Feb 08 10:09:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.