The NEW_TIME function finds out the time in the time zones passing the date and time of the first zone, and specifying the second zone.
The Syntax for the NEW_TIME Function
NEW_TIME(input_dateĀ andĀ time,time_zone1,time_zone2)
What are the valid time zones
Time Zone Abbreviation PassedTime Zone Description
ASTAtlantic Standard Time
ADTAtlantic Daylight Saving Time
BSTBering Standard Time
BDTBering Daylight Saving Time
CSTCentral Standard Time
CDTCentral Daylight Saving Time
ESTEastern Standard Time
EDTEastern Daylight Saving Time
GMTGreenwich Mean Time (Date Line!)
HSTAlaska-Hawaii Standard Time
HDTAlaska-Hawaii Daylight Saving Time
MSTMountain Standard Time
MDTMountain Daylight Saving Time
NSTNewfoundland Standard Time
PSTPacific Standard Time
PDTPacific Daylight Saving Time
YSTYukon Standard Time
YDTYukon Daylight Saving Time