TIMEZONE function

TIMEZONE function

Returns an INTEGER value representing the time zone offset from Coordinated Universal Time (UTC), in minutes. Use this function together with the STRING function to produce the time in hours, minutes, and seconds.

Note: Coordinated Universal Time (UTC) is the current universal standard for time. Local time zone values are relative to UTC. For example, Eastern Standard Time is UTC–05:00.

Syntax
TIMEZONE ( [ datetime-tz-expression | char-expression ] ) 
datetime-tz-expression

An expression whose value is a DATETIME-TZ.

char-expression

A character expression representing the time zone offset. The format of the expression must be +HH:MM.

If the TIMEZONE function has no arguments, it returns the client or server machine that serves as the time source for applications running during the ABL session (specified by the TIME-SOURCE attribute).

Example

Following is an example of using the TIMEZONE function:
DEFINE VARIABLE v-dt-tz AS DATETIME-TZ NO-UNDO 
  INITIAL 2002-05-05T07:15:03.002-05:00. 
DEFINE VARIABLE v-tz    AS INTEGER     NO-UNDO. 
ASSIGN 
  v-tz = TIMEZONE(“+08:00”)  /* v-tz = 480 */ 
  v-tz = TIMEZONE (v-dt-tz). /* v-tz = -300 */ 
See also

ADD-INTERVAL function, DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, INTERVAL function, ISO-DATE function, MONTH function, MTIME function, NOW function, TIME function, TIME-SOURCE attribute, TODAY function, WEEKDAY function, YEAR function, YEAR-OFFSET attribute

TIMEZONE ( [ `datetime-tz-expression` \| `char-expression` ] )

DEFINE VARIABLE v-dt-tz AS DATETIME-TZ NO-UNDO INITIAL 2002-05-05T07:15:03.002-05:00. DEFINE VARIABLE v-tz AS INTEGER NO-UNDO. ASSIGN v-tz = TIMEZONE(“+08:00”) /* v-tz = 480 / v-tz = TIMEZONE (v-dt-tz). / v-tz = -300 */

OpenEdge Release 10.2B