[MDEV-10018] Timestamp with time zone Created: 2016-05-03  Updated: 2023-11-30

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Data types
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: ManasaTulluri Assignee: Ralf Gebhardt
Resolution: Unresolved Votes: 6
Labels: Compatibility, datatype

Issue Links:
Blocks
blocks MDEV-11829 Please add support for datetime with ... Open
blocks MDEV-15751 CURRENT_TIMESTAMP should return a TIM... In Review
blocks MDEV-29564 please add Time format ISO 8601 to DA... Open
is blocked by MDEV-4912 Data type plugin API version 1 Closed
is blocked by MDEV-12514 Split Item_temporal_func::fix_length_... Closed
is blocked by MDEV-16852 Get rid of Item_temporal_hybrid_func:... Closed
is blocked by MDEV-16881 Remove Item::get_temporal_with_sql_mo... Closed
is blocked by MDEV-16939 Move TIMESTAMP truncation code to Fie... Closed
Duplicate
duplicates MDEV-20657 sql_mode="oracle" does not support DA... Closed
PartOf
is part of MDEV-11070 Providing compatibility to other data... Open
Relates
relates to MDEV-32188 make TIMESTAMP use whole 32-bit unsig... In Testing
relates to MDEV-32496 TIMESTAMP variant to support YEAR ran... Open
relates to MDEV-17448 Support DATETIME(6) for ROW START, RO... Open
Epic Link: New data types

 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.

 Comments   
Comment by Sergei Golubchik [ 2016-05-03 ]

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

Comment by Michael Widenius [ 2016-05-30 ]

We are considering to add this to MariaDB 10.2 or 10.3

Comment by Seth Shelnutt [ 2018-02-28 ]

@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.

Comment by Alexander Barkov [ 2019-11-20 ]

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.
Generated at Thu Feb 08 07:39:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.