The T_APP_TIME Table

Previous Next

See Also

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.