How do I change MySQL timezone？
2018-09-07 19:09
However,therearewaysforyoutogetresultsthatareinyourpreferredtimezone.FirstdeterminehowmanyhoursyourdesiredtimezoneisofffromMST.Forexample,ESTis+2hours.PSTis-1hour.
Knowingthetimeoffset,youcanreplaceallyourSQLstatementsof
SELECTNOW();
with
SELECTDATE_ADD(NOW(),INTERVAL2HOUR);
whichwillgiveyouanESTdateresult.ForaresultinPST,youwoulddo:
SELECTDATE_SUB(NOW(),INTERVAL1HOUR);
Ifyouareworkingwithtimeinsecondsinsteadofdates,thenfactorintheoffsetinseconds.Becausethereare3600secondsinanhour,andESTis2hourslaterthanMST,thefollowingconvertstimestampsfromMSTtoEST:
SELECTunix_timestamp()+(3600*2);
SELECTFROM_UNIXTIME(UNIX_TIMESTAMP()+(3600*2));
SeetheMySQLManualsDateandTimeFunctionsformoreinformation.
Dependingonyourapplication,youmayalsoneedtodooneofthefollowing(butnotboth):
1.Findeveryplaceinyourcodewhereadateortimeisdisplayedtothebrowserandhaveauserdefinedfunctionchangeittoaddorsubtracttheappropriatenumberofhoursbeforedisplayingit.
2.Findeveryplaceinyourcodewheredatesortimesareinputintoyoursystemandhaveauserdefinedfunctionaddorsubtracttheappropriatenumberofhoursbeforestoringit.
文章标题：How do I change MySQL timezone？
文章链接：http://soscw.com/essay/15215.html