mysqltimezoneconvert-tz

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

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')
Solution

  • This is a known bug in MySQL:

    MySQL does not recognize timezone offset UTC +14:00