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?】相关文章：
★ 3