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));
SeetheMySQLManual'sDateandTimeFunctionsformoreinformation.
Dependingonyourapplication,youmayalsoneedtodooneofthefollowing(butnotboth):
1.Findeveryplaceinyourcodewhereadateortimeisdisplayedtothebrowserandhaveauserdefinedfunctionchangeittoaddorsubtracttheappropriatenumberofhoursbeforedisplayingit.
2.Findeveryplaceinyourcodewheredatesortimesareinputintoyoursystemandhaveauserdefinedfunctionaddorsubtracttheappropriatenumberofhoursbeforestoringit.
【How do I change MySQL timezone?】相关文章：
★ WinXP + Apache +PHP5 + MySQL + phpMyAdmin安装全功略
★ 3
★ PHP IDE PHPStorm配置支持友好Laravel代码提示方法