convert_tz returns null

mysql ubuntu-12.04 convert-tz
mohur picture mohur · Jan 22, 2013 · Viewed 44.3k times · Source

I know this sounds stupid, but when I use

SELECT CONVERT_TZ('2004-01-01 12:00:00','UTC','Asia/Jakarta') AS time

it outputs NULL. I'm using MySQL Workbench in Ubuntu 12.04 64 bit, and it works in my other laptop/os (also using MySQL Workbench).

Answer

Barmar picture Barmar · Jan 22, 2013

This will happen if you haven't loaded the time zone table into mysql.

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

mysql is the name of the built-in database that holds MySQL-specific configuration data.

Related questions

Extension mysqli is missing, phpmyadmin doesn't work

I have a problem with phpmyadmin on ubuntu 12.04. I have already installed apache2, php5, mysql and phpmyadmin. The phpinfo(); script, don't show nothing about mysqli or mysql extension. When I try start phpmyadmin this error appear: ---- **phpMyAdmin - Error** …

Read More
mysql.h file can't be found

i'm trying to install connection between c++ and mysql in ubuntu 12.04. i've installed mysql-client, mysql-server, libmysqlclient15-dev, libmysql++-dev. but when i try to compile the code i got the error: mysql.h there is no such file. i looked …

Read More
MySQL Job failed to start

I'm on Kubuntu 12.04, and after installing mysql via an apt-get (mysql ver: 5.5.35), i'm trying to start mysql service, but I got this error: sudo service mysql start start: Job failed to start So I googled this problem, it says i …

Read More