mysql - 在 SQL 中更改 UTC/GMT

Question

Select dtCreated, fTotal, txtOrderStatus, txtOrderRef, txtPaymentMethod 
from  order1 
where  txtOrderStatus != ('incomplete')  
AND year(dtCreated)=2015 order by  dtCreated ASC ;

我还需要将时区更改为 GMT +8，我该怎么做？

Answer 1

你可以这样尝试:

SELECT CONVERT_TZ(yourTime,'+00:00','+08:00');

请参阅manual :

CONVERT_TZ() converts a datetime value dt from the time zone given by from_tz to the time zone given by to_tz and returns the resulting value. Time zones are specified as described in Section 10.6, “MySQL Server Time Zone Support”. This function returns NULL if the arguments are invalid.