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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to