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.