Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
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)
%Z The timezone name
Because MariaDB doesn't support a TIMESTAMP WITH TIME ZONE data type yet, they should print:
- for a DATETIME argument — session @@time_zone value
- for a TIMESTAMP argument — UTC
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Stalled
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MENT-1744 [ MENT-1744 ] |
| Assignee | Sergei Golubchik [ serg ] |
| Link | This issue blocks MENT-1744 [ MENT-1744 ] |
| Link | This issue relates to MENT-1744 [ MENT-1744 ] |
| Link | This issue is part of MENT-1744 [ MENT-1744 ] |
| Link | This issue blocks MENT-1744 [ MENT-1744 ] |
| Link | This issue blocks MENT-1744 [ MENT-1744 ] |
| Link | This issue is part of MENT-1744 [ MENT-1744 ] |
| Summary | Add timezone information to DATE_FORMAT and STR_TO_DATE | Add timezone information to DATE_FORMAT |
| Description |
%z and %Z need to be added to the possible options for the format of DATE_FORMAT and STR_TO_DATE
%z The +hhmm or -hhmm numeric timezone (hour and minute offset from UTC) %Z The timezone name |
%z and %Z need to be added to the possible options for the format of DATE_FORMAT (and STR_TO_DATE, if possible)
%z The +hhmm or -hhmm numeric timezone (hour and minute offset from UTC) %Z The timezone name |
| Description |
%z and %Z need to be added to the possible options for the format of DATE_FORMAT (and STR_TO_DATE, if possible)
%z The +hhmm or -hhmm numeric timezone (hour and minute offset from UTC) %Z The timezone name |
%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) %Z The timezone name |
| Assignee | Sergei Golubchik [ serg ] | Rucha Deodhar [ rucha174 ] |
| 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) %Z The timezone name |
%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) %Z The timezone name Because MariaDB doesn't support a TIMESTAMP WITH TIME ZONE data type yet, they should print: * for a DATETIME argument — session @@time_zone value * for a TIMESTAMP argument — UTC |
| Priority | Critical [ 2 ] | Blocker [ 1 ] |
| Link | This issue blocks MENT-1902 [ MENT-1902 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Rucha Deodhar [ rucha174 ] | Oleksandr Byelkin [ sanja ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Rucha Deodhar [ rucha174 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Assignee | Rucha Deodhar [ rucha174 ] | Ramesh Sivaraman [ JIRAUSER48189 ] |
| Component/s | Server [ 13907 ] | |
| Fix Version/s | 11.3.0 [ 29302 ] | |
| Fix Version/s | 11.3 [ 28565 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Fix Version/s | 10.4.32 [ 29300 ] |
| Fix Version/s | 10.4.32 [ 29300 ] |
| Assignee | Ramesh Sivaraman [ JIRAUSER48189 ] | Rucha Deodhar [ rucha174 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.3 [ 28565 ] | |
| Fix Version/s | 11.3.0 [ 29302 ] |
| Link | This issue relates to MDEV-30827 [ MDEV-30827 ] |
| Link | This issue blocks TODO-4253 [ TODO-4253 ] |
| Link | This issue is part of TODO-4253 [ TODO-4253 ] |
| Link | This issue blocks TODO-4253 [ TODO-4253 ] |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Assignee | Rucha Deodhar [ rucha174 ] | Ramesh Sivaraman [ JIRAUSER48189 ] |
| Labels | Preview_11.3 |
| Assignee | Ramesh Sivaraman [ JIRAUSER48189 ] | Rucha Deodhar [ rucha174 ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.3.1 [ 29416 ] | |
| Fix Version/s | 11.3 [ 28565 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue relates to |
Patch: https://github.com/MariaDB/server/tree/bb-11.3-MDEV-31684