Displaying DATETIME-TZ data based on display format

The display of DATETIME-TZ data is affected by the session's time zone offset from UTC. A session's time zone offset is the time zone offset of the SESSION:TIME-SOURCE machine, which is the ABL client/AppServer or database server machine.

If the format for a DATETIME-TZ specifies a time zone offset, the AVM displays the data in the local time of the stored time zone, along with the time zone offset.

If the format does not specify a time zone offset, the AVM displays the DATETIME-TZ in the local time of the session's time zone.

For example, say a DATETIME-TZ field is created in London (time zone UTC+00:00), with a value as above, March 5, 2002 at 7:15:03.002 am.

Using the same formats as above:

"99/99/99 HH:MM:SS.SSS" "99-99-9999 HH:MM AM" "99-99-9999 HH:MM:SS+HH:MM"

The ABL client in London (time zone UTC+00:00) displays the field as follows:

03/05/02 07:15:03.002 03-05-2002 7:15 AM 03-05-2002 07:15:03+00:00

An ABL client in Bedford, MA (time zone UTC-05:00) displays the same field as follows:

03/05/02 02:15:03.002 03-05-2002 2:15 AM 03-05-2002 07:15:03+00:00

An ABL client in San Diego, CA (time zone UTC-08:00) displays the field as follows:

03/04/02 23:15:03.002 03-04-2002 11:15 PM 03-05-2002 07:15:03+00:00

If you want to display DATETIME-TZ data without a time zone offset in a time zone other than the session's time zone (a client in Bedford wants to see DATETIME-TZ data in San Diego local time), use the SESSION:DISPLAY-TIMEZONE attribute.