3.3 Valid Time Constants

The following table lists constants that can be used in the validFrom and validTill timestamps of a WM_PERIOD specification.

(Workspace Manager uses these as constants, but they are implemented as functions.)

Table 3-1 Constants for Valid Time Support

Constant Explanation

DBMS_WM.MIN_TIME

The minimum (earliest) timestamp value supported by Workspace Manager. Currently the beginning of the day on 01-Jan in the year -4712 (4712 BCE).

DBMS_WM.MAX_TIME

The maximum (latest) timestamp value supported by Workspace Manager. Currently the end of the day (11:59.999999000 pm) on 31-Dec-9999.

DBMS_WM.UNTIL_CHANGED

A timestamp that is treated as DBMS_WM.MAX_TIME until a subsequent modification overrides the value.