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.