maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

Hi Experts,

I got this error, not sure whether maria db supports time zone:

MariaDB [devdb]> create table ts (dt datetime, tz timestamp with time zone);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use
near 'time zone)' at line 1

My application team is looking for time zone support. Any thought please.

reference:

https://mariadb.com/kb/en/sql-99/temporal-data-types/#time-with-time-zone