All of the following SESSION handle attributes apply to the DATETIME and DATETIME-TZ data types.

  • SESSION:DATE-FORMAT ( -d ) — Used to set the display format of the date part of DATETIME and DATETIME-TZ; for example, month/day/year (mdy) or year/month/day (ymd).
  • SESSION:YEAR-OFFSET ( -yy ) — The start date for the two-digit year range of 100 years; used to display the DATETIMEand DATETIME-TZ when the format specifies a two-digit year.
  • SESSION:TIME-SOURCE — The ABL client/application server or database server machine that serves as the time source for the TIME, TODAY, NOW, TIMEZONE, and MTIME functions. This source is also used to generate values for DATE, DATETIME and DATETIME-TZ database and temp-table fields with initial values of TODAY or NOW. The TIME-SOURCE attribute overrides the SESSION:TIMEZONE attribute.
  • SESSION:TIMEZONE — An INTEGER value that specifies the time zone offset from UTC, in minutes, that ABL uses in the TODAY, TIME, NOW, MTIME and TIMEZONE functions. This source is also used to generate values for DATE, DATETIME and DATETIME-TZ database and temp-table fields with initial values of TODAY or NOW. The SESSION:TIME-SOURCE attribute overrides the TIMEZONE attribute.
  • SESSION:DISPLAY-TIMEZONE — The time zone for displaying DATETIME-TZ data without a time zone offset.