[MDEV-31684] Add timezone information to DATE_FORMAT Created: 2023-07-13 Updated: 2024-02-02 Resolved: 2023-10-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | 11.3.1 |
| Type: | Task | Priority: | Blocker |
| Reporter: | Ralf Gebhardt | Assignee: | Rucha Deodhar |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Preview_11.3 | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
%z and %Z need to be added to the possible options for the format of DATE_FORMAT %z The +hhmm or -hhmm numeric timezone (hour and minute offset from UTC) Because MariaDB doesn't support a TIMESTAMP WITH TIME ZONE data type yet, they should print:
|
| Comments |
| Comment by Rucha Deodhar [ 2023-08-08 ] |
|
Patch: https://github.com/MariaDB/server/tree/bb-11.3-MDEV-31684 |
| Comment by Rucha Deodhar [ 2023-09-01 ] |
|
Pushed to preview. |
| Comment by Ramesh Sivaraman [ 2023-10-03 ] |
|
okay to push |
| Comment by Rucha Deodhar [ 2023-10-11 ] |
|
pushed to 11.3 |