Bug #109865 convert_tz is unable to calculate correct timezone for Brazil airport

• Submitted: 31 Jan 2023 17:32
• Modified: 7 Feb 2023 12:41
• Reporter: Srav Recharla
• Status: Unsupported
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.6.45
• OS: Any
• CPU Architecture: Any

[31 Jan 2023 17:32] Srav Recharla

Description:
We are trying to calculate timezone conversion for SAO PAULO/GUARULHOS airport so the place is SAO PAULO 
SELECT convert_tz( '2023-01-22 22:38:00', 'Etc/UTC', 'America/Sao_Paulo') 
The query gives output as 22:47 which is (GMT-2), but the timings should be GMT-3. 

How to repeat:
We are trying to calculate timezone conversion for SAO PAULO/GUARULHOS airport so the place is SAO PAULO 
SELECT convert_tz( '2023-01-22 22:38:00', 'Etc/UTC', 'America/Sao_Paulo') 
The query gives output as 22:47 which is (GMT-2), but the timings should be GMT-3.

[7 Feb 2023 12:41] MySQL Verification Team

Hi Mr. Recharia,

Thank you for reporting a problem.

However, version 5.6 is not supported nor maintained any more ....... Please, try our latest 8.0.

When you report next time this sort of problems do make sure to provide the reasoning on why is the result wrong.

Unsupported.