|
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()+(36002); SELECTFROM_UNIXTIME(UNIX_TIMESTAMP()+(36002)); SeetheMySQLManual'sDateandTimeFunctionsformoreinformation. Dependingonyourapplication,youmayalsoneedtodooneofthefollowing(butnotboth): 1.Findeveryplaceinyourcodewhereadateortimeisdisplayedtothebrowserandhaveauserdefinedfunctionchangeittoaddorsubtracttheappropriatenumberofhoursbeforedisplayingit. 2.Findeveryplaceinyourcodewheredatesortimesareinputintoyoursystemandhaveauserdefinedfunctionaddorsubtracttheappropriatenumberofhoursbeforestoringit.
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
