0

I have been trying to find why CONVERT_TZ(YYYY-MM-DD HH:MM:SS, "Europe/Athens", "America/Chicago") in MySQL Workbench output only null.

I found this and found the answer to my question. I have to load the timezones in MySQL. But I use my database locally and not on a server.

do you know if there is any equivalent command or any way to have the expected output of CONVERT_TZ locally?

Kiriakospapa
  • 39
  • 4
  • Are mentioned zones known to your MySQL instance? Check that they are present in `select * from mysql.time_zone_name;` – Akina Sep 08 '21 at 10:27

0 Answers0