convert_tz returns null

by

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.

More Related Contents:

  1. MySQL CONVERT_TZ()
  2. How to Convert UTC Date To Local time Zone in MySql Select Query
  3. Can MySQL convert a stored UTC time to local timezone?
  4. In SQL Server how to get the count of child if both parent and child are available [closed]
  5. Get a list of dates between two dates
  6. Calculate a running total in MySQL
  7. How to change max_allowed_packet size
  8. What does character set and collation mean exactly?
  9. How do MySQL indexes work?
  10. How to change MySQL data directory?
  11. GROUP_CONCAT ORDER BY
  12. MySQL LIMIT clause equivalent for SQL SERVER
  13. How to get the next auto-increment id in mysql
  14. Importing a csv into mysql via command line
  15. MySQL dynamic-pivot
  16. Find and Replace text in the entire table using a MySQL query
  17. Can I reuse a calculated field in a SELECT query?
  18. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  19. Deleting duplicate rows from a table
  20. Is it safe to store usernames and passwords in the database?
  21. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  22. ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
  23. Compare only day and month with date field in mysql
  24. mysql, ifnull vs coalesce, which is faster?
  25. MySQL delimiter syntax error
  26. Can a MySQL query turn rows into columns?
  27. How to import large sql file in phpmyadmin
  28. How to figure out size of Indexes in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment