MySQL CONVERT_TZ() returns null when one of the arguments is "+14:00"

Question

I am trying to convert UTC time into the users local time, it works fine until I try to convert the time to +14:00 timezone, the result is always null, anyone has idea? Here is my code:

select CONVERT_TZ(now(), '+00:00', '+14:00')

Answer 1

This is a known bug in MySQL:

MySQL does not recognize timezone offset UTC +14:00