[Converting Timezone]

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

Liselot

[Converting Timezone]

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

[Converting Timezone]

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

[Converting Timezone]

I get COUNT(*) = 474

[Converting Timezone]

I tried

SELECT CONVERT_TZ(NOW(),'Europe/Amsterdam','UTC')

The result is NULL

[Converting Timezone]

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?