search

Home >Database >Mysql Tutorial >How to convert time zone in MySQL

How to convert time zone in MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBforward
2023-05-28 18:02:57877browse

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

Related articles

See more