convert_tz

Syntax

DATETIME CONVERT_TZ(DATETIME dt, VARCHAR from_tz, VARCHAR to_tz)

Description

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

Example

  1. mysql> select convert_tz('2019-08-01 13:21:03', 'Asia/Shanghai', 'America/Los_Angeles');
  2. +---------------------------------------------------------------------------+
  3. | convert_tz('2019-08-01 13:21:03', 'Asia/Shanghai', 'America/Los_Angeles') |
  4. +---------------------------------------------------------------------------+
  5. | 2019-07-31 22:21:03                                                       |
  6. +---------------------------------------------------------------------------+
  8. mysql> select convert_tz('2019-08-01 13:21:03', '+08:00', 'America/Los_Angeles');
  9. +--------------------------------------------------------------------+
  10. | convert_tz('2019-08-01 13:21:03', '+08:00', 'America/Los_Angeles') |
  11. +--------------------------------------------------------------------+
  12. | 2019-07-31 22:21:03                                                |
  13. +--------------------------------------------------------------------+

keyword

  1. CONVERT_TZ