STD.Date.TimeZone.SecondsBetweenTZ( fromTimeZoneAbbrev, toTimeZoneAbbrev, [fromLocation, ] [toLocation ] )
fromTimeZoneAbbrev | REQUIRED. The time zone abbreviation designated as the starting point; must be a non-empty uppercase string. |
toTimeZoneAbbrev | REQUIRED. The time zone abbreviation designated as the ending point; must be a non-empty uppercase string. |
fromLocation | OPTIONAL. The name of the location that goes along with fromTimeZoneAbbrev; if a location is not provided or is an empty string, the first record matching fromTimeZoneAbbrev is used. |
toLocation | OPTIONAL. The name of the location that goes along with toTimeZoneAbbrev; if a location is not provided or is an empty string, the first record matching toTimeZoneAbbrev is used. |
Returns: | The number of seconds between the two time zones; returns zero if either time zone cannot be found |
The STD.Date.TimeZone.SecondsBetweenTZ function computes the offset, in seconds, between two different time zones. Each time zone is designated by a required time zone abbreviation and an optional location name. The result is the number of seconds (which can be either positive or negative) that would have to be applied to a time when traveling from fromTimeZoneAbbrev to toTimeZoneAbbrev.
Be aware that some time zones explicitly represent daylight savings time, so it is entirely possible to change not only time zones but DST observance as well in a single call.
Example:
MPORT STD; STD.Date.TimeZone.SecondsBetweenTZ('CST','IST','NORTH AMERICA','');
See Also: AdjustTimeTZ