maria-discuss team mailing list archive
Mailing list archive
Re: timestamp with time zone support mariaDB 10.1.14
Brian Evans <grknight@xxxxxxxxxxxxxx>
Thu, 23 Feb 2017 09:41:48 -0500
Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.7.1
On 2/23/2017 9:11 AM, Karthick Subramanian wrote:
> 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
> 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.
TIMESTAMP columns are limited to the valid UNIX timestamps (and subject
to the year 2038 problem) but adjust to the time_zone variable (global
or session) automatically.
DATETIME can store much more but you will need to store/retrieve
consistent values with functions like CONVERT_TZ.
By the way.. the SQL 99 is a copy of a book and not necessarily
implemented in MariaDB.
Please follow the documentation listed at
https://mariadb.com/kb/en/mariadb/documentation/ for what is existing in