29、CONVERT_TZ(date,from_tz ,to_tz ):轉(zhuǎn)換時區(qū) 1 SELECT CONVERT_TZ(‘2004-01-01 12:00:00','+00:00','+10:00') 1 -> 2004-01-01 22:00:00 30、STR_TO_DATE(date,format ):將字符串轉(zhuǎn)成format格式的日期時間 1 SELECT STR_TO_DATE(‘2015-01-01', ‘%Y-%m-%d') 1 -> 2015...
www.dbjr.com.cn/article/1358...htm 2025-6-2