[MDEV-11829] Please add support for datetime with time zone literals (ISO6801) Created: 2017-01-18 Updated: 2023-11-30 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major |
| Reporter: | Chris Calender (Inactive) | Assignee: | Alexander Barkov |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | contribution, foundation | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||||||||||
| Epic Link: | New data types | ||||||||||||||||||||||||||||||||||||||||||||
| Description |
|
This is a feature request requesting to please add support for datetime with time zone literals (ISO6801). A valid value with this format would be: 2016-12-10T10:10:10-05:00 As far as I know, we do support part of ISO6801, which is: 2016-12-10T10:10:10 However, we do not support the trailing time zone literal ("-05:00" in this case). For reference, this code revision is what mentions the partial support of ISO6801: At least the following formats are recogniced (based on number of digits) Also, this bug is spawned off of the following bug (which was designated "not a bug", thus I wanted to file a feature request for the future): https://jira.mariadb.org/browse/MDEV-11576 Thank you for your consideration. |
| Comments |
| Comment by Daniel Black [ 2017-03-11 ] |
|
ccalender, as indicated the referenced pull request implements the form ...<time>(±hh:mm|Z) What isn't implemented is the ISO8601 representations of timezone offsets in these forms
Are these important to you? Is it worth doing for completeness sake? Are the ordinal or week forms of ISO8601 important to you? |
| Comment by Chris Calender (Inactive) [ 2017-03-16 ] |
|
Hi Daniel, Yes, the following are important (specifically the first one): ...<time>±hhmm I think that part would be worth doing. |
| Comment by Shahriyar Imanov [ 2022-12-10 ] |
|
5 years.... |