Home >Database >Mysql Tutorial >How to convert time zone in MySQL
How to convert time zone in MySQL
- WBOYforward
- 2023-05-28 18:02:57838browse
CONVERT_TZ(date,from_tz,to_tz): Convert time zone
SELECT CONVERT_TZ(‘2004-01-01 12:00:00','+00:00','+10:00')
-> 2004-01-01 22:00:00
The above is the detailed content of How to convert time zone in MySQL. For more information, please follow other related articles on the PHP Chinese website!
Statement：
This article is reproduced at:yisu.com. If there is any infringement, please contact admin@php.cn delete
Previous article：Sample analysis of MySQL table filesNext article：Sample analysis of MySQL table files