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.