| Bug #118492 | The result returned by the DIAMETER_TZ function is incorrect. The time after conversion is expected. | ||
|---|---|---|---|
| Submitted: | 20 Jun 3:07 | Modified: | 1 Jul 12:40 |
| Reporter: | Alice Alice | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
| Version: | 8.0.41, 8.0.42 | OS: | Linux |
| Assigned to: | CPU Architecture: | x86 | |
[20 Jun 6:01]
MySQL Verification Team
Hello Alice Alice, Thank you for the report and feedback. regards, Umesh
[1 Jul 12:40]
MySQL Verification Team
Hello Alice,
My senior colleague Shane corrected my verification steps and pointed that we have to install timezone tables. Could you please confirm at your end? Thank you.
-- 8.0.42
bin/mysql -uroot -S/tmp/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.42 MySQL Community Server - GPL
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
+-----------------------------------------------+
| CONVERT_TZ('2004-01-01 12:00:00','GMT','MET') |
+-----------------------------------------------+
| NULL |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM | SYSTEM |
+--------------------+---------------------+
1 row in set (0.00 sec)
mysql> \q
Bye
-- installed the timezone tables
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html#time-zone-installation
bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | bin/mysql -uroot -S/tmp/mysql.sock mysql
-- confirmed that it works
bin/mysql -uroot -S/tmp/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.42 MySQL Community Server - GPL
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
+-----------------------------------------------+
| CONVERT_TZ('2004-01-01 12:00:00','GMT','MET') |
+-----------------------------------------------+
| 2004-01-01 13:00:00 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>
regards,
Umesh
Description: mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); +-----------------------------------------------+ | CONVERT_TZ('2004-01-01 12:00:00','GMT','MET') | +-----------------------------------------------+ | NULL | +-----------------------------------------------+ 1 row in set (0.00 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.41 | +-----------+ 1 row in set (0.00 sec) How to repeat: SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');