Time Columns

Imagine you manage a sports club and want to track the starting time and ending time of training sessions in your database. In this case, the Time columns will help you indicate the time in a suitable format.

When displayed or converted to text, the time format is automatically determined based on the Language and Location settings specified in the user profile.
In cases where the data is accessed by someone who is not a database user, the Language and Location settings specified in the database properties are used to determine the text representation of the time.

General Properties

If a column contains data that doesn’t look or behave the way you want, you can edit the column’s General Properties and the properties defined by the column type.

Time Options

Properties defined by the column type:

Format

This property allows a user to specify the format in which the time value will be represented. The following options are possible:

• HH:MM - time is displayed in the hours:minutes format;
• HH:MM:SS - time is displayed in the hours:minutes:seconds format.

Help

When the Help text property is filled in, a question mark is displayed near the field name on the View/Edit form. If you point to this question mark, a pop-up with a tip or a help text message will be shown.