Hello,
I cannot convert timezones using the CONVERT_TZ() function. I get NULL as a result.
I imported the timezone information using ./mysql_tzinfo_to_sql /usr/share/zoneinfo | ./mysql -u root -p mysql after first removing the +VERSION file. I've stopped and restarted the MySQL-server and rebooted my system, but it didn't help.
I've checekd the number of records in the time_zone_name table with
SELECT COUNT(*) FROM mysql.time_zone_name;
and there are 474 records found. But
SELECT message_id, subject, CONVERT_TZ(date_entered, 'UTC', 'America/New_York') AS local FROM messages ORDER BY date_entered DESC LIMIT 1;
still gives NULL as a result for local.
Can anybody help me out?