Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30827

Function to print a time zone abbreviation for a given time zone at a given date

Details

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Time zones
    • None

    Description

      I want to get the time zone from a date+time plus location. Some cities in the world exist in different time zones, depending on the time of the year.

      Something like `TIME_ZONE_ABBREVIATION(dateTimeExpression, timeZoneLocation)`.

      2022-01-01 00:00:00 in Europe/Amsterdam should give CET.
      		 
      2022-06-01 00:00:00 in Europe/Amsterdam should give CEST.
      		 
      2022-01-01 00:00:00 in Europe/Istanbul should give EET.

      Time zone information is not stored along date time values, which make this a hard or impossible task to work around.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-31684 Add timezone information to DATE_FORMAT

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          links to

          Web Link Same DBA stack exchange question

          Activity

            Ascending order - Click to sort in descending order
            user2180613 Remy Fox created issue -
            user2180613 Remy Fox made changes -
            Field Original Value New Value
            Description I want to get the time zone from a date+time plus location. Some cities in the world exist in different time zones, depending on the time of the year.

            Something like `TIME_ZONE_ABBREVIATION(dateTimeExpression, timeZoneLocation)`.

            {{2022-01-01 00:00:00 in Europe/Amsterdam should give CET.
            2022-06-01 00:00:00 in Europe/Amsterdam should give CEST.
            2022-01-01 00:00:00 in Europe/Istanbul should give EET.}}

            Time zone information is not stored along date time values, which make this a hard or impossible task to work around.             		I want to get the time zone from a date+time plus location. Some cities in the world exist in different time zones, depending on the time of the year.

            Something like `TIME_ZONE_ABBREVIATION(dateTimeExpression, timeZoneLocation)`.

            {code:java}
            2022-01-01 00:00:00 in Europe/Amsterdam should give CET.
            2022-06-01 00:00:00 in Europe/Amsterdam should give CEST.
            2022-01-01 00:00:00 in Europe/Istanbul should give EET.
            {code}


            Time zone information is not stored along date time values, which make this a hard or impossible task to work around.
            danblack Daniel Black made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Component/s Time zones [ 10108 ]
            serg Sergei Golubchik made changes -
            issue.field.resolutiondate 2023-05-22 22:04:13.0 2023-05-22 22:04:13.378
            serg Sergei Golubchik made changes -
            Fix Version/s N/A [ 14700 ]
            Assignee Sergei Golubchik [ serg ]
            Resolution Won't Fix [ 2 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Summary Create a function to format a date + time to show the time zone at a given location. Function to print a time zone abbreviation for a given time zone at a given date
            serg Sergei Golubchik made changes -
            Resolution Won't Fix [ 2 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Fix Version/s N/A [ 14700 ]

            People

              Unassigned Unassigned
              user2180613 Remy Fox
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.