CONVERT_TZ(dt,from_tz,to_tz)

来源：互联网发布：财神软件下载编辑：程序博客网时间：2024/06/09 05:01

转换datetime值dt，从 from_tz 由给定转到 to_tz 时区给出的时区，并返回的结果值。如果参数无效该函数返回NULL。

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> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00');+---------------------------------------------------------+| CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00')     |+---------------------------------------------------------+| 2004-01-01 22:00:00                                     |+---------------------------------------------------------+1 row in set (0.00 sec)

0 0