21 Nov 2023

Ubuntu - MySQL - convert_tz returns null

In Ubuntu, convert_tz function in MySQL was returning NULL for me.

To handle this, I used this solution mentioned here. PFB the steps for quick reference.

  • Go to Terminal
  • Execute the command
    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
  • Now, convert_tz will return a non NULL value

No comments:

Post a Comment