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