mysql - MySQL 中的 CONVERT_TZ

Question

我到底如何使用以下代码来抵消 DST+1 小时:

SELECT datetime 
FROM events 
WHERE datetime > NOW() 
GROUP BY datetime 
ORDER BY datetime

从我在互联网上看到的各种示例中，我无法完全弄清楚如何做到这一点，例如:

SELECT CONVERT_TZ(datetime,'+00:00','+01:00')

干杯!

Answer 1

试试这个:

SELECT CONVERT_TZ(datetime,'+00:00','+01:00') as conv_dt
FROM events
WHERE datetime > NOW() 
GROUP BY conv_dt 
ORDER BY conv_dt;