1 1 12 Time

Time is a fixed-length field with a length of 8, containing a time in ISO format: HH:MM:SS. The *NULL value is 00:00:00 (i.e. midnight).

Field Definition Rules

Rules for defining an Integer in the repository are:

Length	Times must be 8 in length. Times have no decimals.
Valid Keyboard Shift	Blanks
Allowed Attributes	AB, ASQN, CS, FE, ISO, ND, RA, RL, RLTB, TIMC, TIMU, TIMX. Note: ISO display format must be selected.
Edit Mask	Not allowed.
Default	*SQLNULL. ASQN will be enabled by default.

Field Definition Notes

Usage Rules

Partition Type	RDMLX Enabled Partition
Files	Times may only be used in RDMLX Files. Times may be used as real fields. Use of Times as key fields is not recommended. If used as key fields, take note of the Warning below.
Logical Views	Use of Times as key fields is not recommended.
Virtual Fields	Times may be used with Code Fragment Virtual Fields.
Predetermined Join Fields	Not allowed.
RDML Commands	Times are classified as their own types and are not valid for numeric or alpha command parameters in RDML commands.
Built-In Functions	When used in Built-In Functions, Times are classified as their own types and are not valid for numeric or alpha arguments.
Special Values	NULL, NAVAIL, *REMEMBERED_VALUE
Conversion	Date fields may be converted to alpha, signed, packed, string or char. Refer to Field Type Conversions.

Usage Notes

Working fields may be defined as TYPE(*TIME). Time literals are always specified in ISO format; for example: 22:58:35 or 03:08:05. Note that seconds are optional (if omitted, they are assumed to be zero), so 22:58 or 03:08 would also be valid.

Platform Considerations

Warning

Tips & Techniques

To use a Time field, #MyTime, as an alpha argument, you simply use #MyTime.asString, explicitly stating that you want to use the string representation.

Also See