liselot

To Antonio: thank you for your suggestion, I will keep this in mind. Liselot

I'm running MySQL Server version: 5.6.15 - MySQL Community Server (GPL) on Mac OS X 10.9.2

This results in: Name = Europe/Amsterdam, Time_zone_id = 415

I get COUNT(*) = 474

I tried SELECT CONVERT_TZ(NOW(),'Europe/Amsterdam','UTC') The result is NULL

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?