ABL datetime data types

The datetime data types introduce a data type into the OpenEdge language that includes a time component. The DATETIME-TZ data type extends the DATETIME data type with a time zone component. For the DataServer, the ABL datetime data types enable you to manage date and time data from your OpenEdge application and from the foreign data source as one element instead of two separate entities. The timezone offset provides you with additional ability to manage data that spans time zones.

The following table provides definitions of the ABL datetime data types:

Table 1. ABL datetime data types
Data Type Definition
DATETIME The DATETIME data type consists of two parts, one an ABL date and one an ABL time. The unit of time is milliseconds from midnight. DATETIME is equivalent to Oracle TIMESTAMP.
DATETIME-TZ The ABL DATETIME-TZ is a variation of the DATETIME data type that includes a time zone offset. Its Oracle equivalent is TIMESTAMP WITH TIMEZONE.