Jump to content
Larry Ullman's Book Forums


  • Posts

  • Joined

  • Last visited

liselot's Achievements


Newbie (1/14)



  1. To Antonio: thank you for your suggestion, I will keep this in mind. Liselot
  2. I'm running MySQL Server version: 5.6.15 - MySQL Community Server (GPL) on Mac OS X 10.9.2
  3. I tried SELECT CONVERT_TZ(NOW(),'Europe/Amsterdam','UTC') The result is NULL
  4. 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?
  • Create New...