Why Does My MySQL CONVERT_TZ Function Return NULL?

CONVERT_TZ Function Returns Null

When attempting to use the CONVERT_TZ function in a MySQL query to convert a timestamp from one time zone to another, some users encounter a puzzling issue: the result is null.

Solution:

This occurs if the MySQL time zone table has not been loaded. To resolve this, execute the following command:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

In this command, mysql represents the built-in database that stores MySQL-specific configuration data. By running this command, you import the time zone data into the MySQL database, enabling the CONVERT_TZ function to operate correctly.

The above is the detailed content of Why Does My MySQL CONVERT_TZ Function Return NULL?. For more information, please follow other related articles on the PHP Chinese website!