Release 10.1A: OpenEdge Development:
Progress 4GL Reference

> ## DATETIME-TZ function

> Converts a date, time, and time zone value, or a character string, into a DATETIME-TZ.

> Note: If any argument is the Unknown value (`?`), the result is the Unknown value (`?`).

> #### Syntax

>     DATETIME-TZ (date-exp [, mtime-exp [, timezone-exp ] ] )

>     DATETIME-TZ (datetime-exp [, timezone-exp ] )

>     DATETIME-TZ (datetime-tz-exp [, timezone-exp ] )

>     DATETIME-TZ (month, day, year, hours, minutes [, seconds [, milliseconds
>       [, timezone-exp ] ] ] )

>     DATETIME-TZ ( string )

> ``date-exp``

> An expression whose value is a DATE.

> ``mtime-exp``

> An expression whose value is an integer representing the number of milliseconds since midnight.

> ``timezone-exp``

> An expression whose value is an integer representing the time zone offset from Coordinated Universal Time (UTC) in minutes. If not specified, the function uses the session’s time zone.

> ``datetime-exp``

> An expression whose value is a DATETIME.

> ``datetime-tz-exp``

> An expression whose value is a DATETIME-TZ. Use this option to convert a DATETIME-TZ from one time zone to another.

> ``month``

> An expression whose value is an integer from 1 to 12, inclusive.

> ``day``

> An expression whose value is an integer from 1 to the highest valid day of the month.

> ``year``

> An expression that evaluates to a year.

> ``hours``

> An expression whose value is an integer from 0 to 23, inclusive.

> ``minutes``

> An expression whose value is an integer from 0 to 59, inclusive.

> ``seconds``

> An expression whose value is an integer from 0 to 61, inclusive. The upper limit is 61 for leap seconds.

> ``milliseconds``

> An expression whose value is an integer from 0 to 999, inclusive.

> ``string``

> A character expression whose value is a string containing a DATETIME-TZ. The date portion of the string must have the format specified by the DATE-FORMAT attribute. The time portion must be in a valid time format (HH:MM:SS, and so on). If the string contains a time zone, it must be in +HH:MM format. If the string does not contain a time zone, the DATETIME-TZ inherits the session’s time zone.

> Example

> Following is an example of using the DATETIME-TZ function:

>     DEF VAR my-datetime-tz as DATETIME-TZ.

>     my-datetime-tz = DATETIME-TZ(TODAY, MTIME, TIMEZONE).
>     /* The statement above is equivalent to "my-datetime-tz = NOW". */

> The following statements result in the same DATETIME-TZ value (when SESSION:DATE-FORMAT is `mdy`):

>     my-datetime-tz = DATETIME-TZ(5, 5, 2002, 7, 15, 3, 0, -300).
>     my-datetime-tz = DATETIME-TZ(“05-05-2002 07:15:03-05:00”).

> #### See also

> DATE function, DATE-FORMAT attribute, DATETIME function, MTIME function, NOW function, TIME function, TIMEZONE function, TODAY function

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095