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).
Please review the general 1.1.1 Field Type Considerations.
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
- By default, Times are ISO format.
Usage Rules
|
Partition Type |
|
|
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
- Refer to Platform Considerations in 1.1.1 Field Type Considerations.
Warning
- If this field is used as a key field, remove the *SQLNULL and ASQN attributes.
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