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. |
Parent topic: Workspace Manager Valid Time Support