You need to specify the format in which you want time stamp type fields reported. The date and time formats are shown in the following table. Any time stamp field specified in FIELDS without a format is assigned the default of TIMET.
Type | Output format | Output field length |
---|---|---|
DATE | mm/dd/yyyy | 10 |
DATEISO | yyyy-mm-dd | 10 |
DATEM | mm/dd | 5 |
DATEYR | mm/dd/yy | 8 |
TIMET | hh:mm:ss.thm | 12 |
TIMEM | hh:mm | 5 |
TIMES | hh:mm:ss | 8 |
DATETIM | yyyy-mm-dd hh:mm:ss | 19 |
TIMEP (output format determined by the PRECISION(n) operand: 4, 5, or 6 decimal places) | hh:mm:ss.thmi | 13 |
hh:mm:ss.thmij | 14 | |
hh:mm:ss.thmiju | 15 |
These format options are most commonly used with the START and STOP operands.
CICSPA LIST(FIELDS(TRAN,TERM,USERID,
START(DATEYR,TIMET),
STOP(TIMEM)))