Oracle datetime data types

Oracle datetime data types provide functionality similar to the ABL datetime data types. The following table provides their definitions:

Table 1. Oracle datetime data types
Data Type Description
TIMESTAMP Includes year, month, day values of date and hour, minute, second values of time with an optional fractional seconds portion. This is the Oracle equivalent of the ABL DATETIME field.
TIMESSTAMP WITH TIME ZONE Contains all the values and default precisions of TIMESTAMP including the time zone displacement value. This is the Oracle equivalent of an ABL DATETIME-TZ field.
TIMESTAMP WITH LOCAL TIME ZONE Contains all the same values and default precisions as TIMESTAMP and are stored without a time zone displacement defined by the database. All stored values are normalized to the database time zone and stored as timestamps without time zone displacement.