The T_APP_TIME Table

The T_APP_TIME table is predefined in every user application definition, and can be created in the same way other tables are created. When the application timer is running, table T_APP_TIME contains exactly one record that reflects the current "application" date and time.

Constraints that are defined on T_APP_TIME, and that are successful, have the effect of scheduled updates of the database.

The T_APP_TIME table contains the following columns:

·	APP_WEEKDAY (1=Sunday, 7=Saturday)

·	APP_YEAR (4 digits, not century based)

·	APP_MONTH (1=January, 12=December)

APP_DAY

APP_HOUR

·	APP_MINUTE

·	APP_SECOND

All columns have the NUMBER data type and contain an integer.