CONVERT_TZ()

函数说明

CONVERT_TZ() 函数用于将给定的日期时间从一个时区转换为另一个时区。如果参数无效，则函数将返回 NULL。

函数语法

  1. > CONVERT_TZ(dt,from_tz,to_tz)

参数释义

参数说明
dt必要参数。要转换的给定日期时间。
from_tz必要参数。当前时区的标识
to_tz必要参数。新的时区的标识

示例

  1. mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
  2. +-------------------------------------------+
  3. | convert_tz(2004-01-01 12:00:00, GMT, MET) |
  4. +-------------------------------------------+
  5. | 2004-01-01 13:00:00                       |
  6. +-------------------------------------------+
  7. 1 row in set (0.00 sec)
  9. mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00');
  10. +-------------------------------------------------+
  11. | convert_tz(2004-01-01 12:00:00, +00:00, +10:00) |
  12. +-------------------------------------------------+
  13. | 2004-01-01 22:00:00                             |
  14. +-------------------------------------------------+
  15. 1 row in set (0.01 sec)
  17. mysql> select convert_tz('2023-12-31 10:28:00','+08:00', 'America/New_York') as dtime;
  18. +---------------------+
  19. | dtime               |
  20. +---------------------+
  21. | 2023-12-30 21:28:00 |
  22. +---------------------+
  23. 1 row in set (0.00 sec)
  25. mysql> select convert_tz(NULL,'-05:00', '+05:30') as dtime;
  26. +-------+
  27. | dtime |
  28. +-------+
  29. | NULL  |
  30. +-------+
  31. 1 row in set (0.00 sec)