Date and Time Fields
*DATE
A character field containing text that can be read as a date in DMY, MDY or YMD format.
Regardless of the original format, when read by the Log File Monitor, the values are returned as numeric fields containing a date in YYYYMMDD format. If the field contains an invalid date, it is in error and cannot be used, except by the %ERROR function. The formats are flexible.
Any of the following are acceptable:
For *DMY:
- DD-MON-YY
- DD-MM-YY
- DDMMYY
For *MDY:
- MM-DD-YY
- MMDDYY
For *YMD:
- YY-MM-DD
- YYMMDD
Where:
| DD | are two day digits, or may be just one digit with the DDMMYY format or when date separators are used. |
| MM | are two month digits, or may be just one digit when date separators are used. |
| YY | are either two or four year digits. |
| MON | This is a three character month abbreviation, not case sensitive, as defined by messages TXT0345 to TXT0356 inclusive in HALMSGF. |
| / - . | Is a forward slash, dash or period used as a date separator. |
*TIME
A character field containing text that can be read as a time. Regardless of the original format, when read by the Log File Monitor, the values are returned as numeric fields containing a date in HHMMSS format. If the field contains an invalid time, it is in error and cannot be used, except by the %IF and %ERROR functions. The format is flexible.
Any of the following are acceptable:
- HH:MM:SS:MMM
- HH:MM:SS
- HHMMSS
- HH:MM
- HHMM
Where:
| HH | Are two hours digits, or may be just one digit when time separators are used. |
| MM | Are two minutes digits, or may be just one digit when time separators are used. |
| SS | Are two seconds digits, or may be just one digit when time separators are used. |
| MMM | Are three milliseconds digits which are ignored. |
| : . | Is a colon or period used as a time separator. |
*MS
A character field containing text that can be read as a time. This field returns the milliseconds part of the value. If the field contains an invalid time, it is in error and cannot be used, except by the %ERROR function.
The format is:
- HH:MM:SS:MMM
Where:
| HH | Are two hours digits, or may be just one digit when time separators are used. |
| MM | Are two minutes digits, or may be just one digit when time separators are used. |
| SS | Are two seconds digits, or may be just one digit when time separators are used. |
| MMM | Are three milliseconds digits |
| : . | Is a colon or period used as a time separator. |
These QSYS.LIB field types are not supported in Log File Monitor
| Type H | Hexadecimal |
| Type J | DBCS only |
| Type E | DBCS either |
| Type O | DBCS open |
| Type 5 | Binary character |
QSYS.LIB field types mapped to other types:
| Type L – Date | Contains a date in “YYYY-MM-DD” format. Use field type *YMD. |
|
Type T – Time |
Contains a time in “HH.MM.SS” format. Use field type *TIME. |
| Type Z – Timestamp |
Contains a timestamp in “YYYY-MM-DD-HH.MM.SS.DDDDDD” format. Use three separate fields with types *YMD, *TIME and *ZONE. |