Details

    Description

      Original Description:

      Hi Team,

      Is there any alternative for "timestamp with timezone" columns in mariadb?

      Is it being developed or released anytime soon in future versions?

      Thanks & Regards,
      Manasa Tulluri.

      Implementation details

      TIMESTAMP WITH TIME ZONE should be implemented to support YEARs in the range at least -4713 .. +9999. See MDEV-32496 for details.

      Attachments

        Issue Links

          Activity

            Yes, there are plans to do it. But at the moment there's nothing final yet.

            serg Sergei Golubchik added a comment - Yes, there are plans to do it. But at the moment there's nothing final yet.

            We are considering to add this to MariaDB 10.2 or 10.3

            monty Michael Widenius added a comment - We are considering to add this to MariaDB 10.2 or 10.3
            Shelnutt2 Seth Shelnutt added a comment -

            @cvicentiu As discussed at the developer unconference, I would like to contribute and have this issue assigned me to for the 10.4 milestone. Before I start I'll post a general design for review to make sure the approach is agreed upon.

            Shelnutt2 Seth Shelnutt added a comment - @cvicentiu As discussed at the developer unconference, I would like to contribute and have this issue assigned me to for the 10.4 milestone. Before I start I'll post a general design for review to make sure the approach is agreed upon.
            bar Alexander Barkov added a comment - - edited

            It seems TIMESTAMP WITH TIMEZONE will need changes in the client-server library:

            • either extend the existing MYSQL_TIME with a new field for time zone
            • or introduce a new C type for it, e.g. MYSQL_TIME_WITH_TIMEZONE.
            bar Alexander Barkov added a comment - - edited It seems TIMESTAMP WITH TIMEZONE will need changes in the client-server library: either extend the existing MYSQL_TIME with a new field for time zone or introduce a new C type for it, e.g. MYSQL_TIME_WITH_TIMEZONE.

            People

              bar Alexander Barkov
              Manasa ManasaTulluri
              Votes:
              7 Vote for this issue
              Watchers:
              14 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.