← Back to team overview

maria-discuss team mailing list archive

Re: timestamp with time zone support mariaDB 10.1.14


Thank you Brian and Sergei.

Actually I have read that disclaimer on the top. But still I don't want to
believe that time zone support is not available in our Maria DB. I am
trying to convince myself the reality now.

Thank you all for your prompt response.

On Thu, Feb 23, 2017 at 8:11 PM, Brian Evans <grknight@xxxxxxxxxxxxxx>

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