Try OpenEdge Now
skip to main content
ABL Data Types Addenda
DATETIME and DATETIME-TZ data types : SESSION handle attributes
 

SESSION handle attributes

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/AppServer 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.
* Precedence of default time zone sources for ABL time date functions