Source Format
Mandatory.
Specify the date format which is currently being used by the Source Column in the table.
Rules
Valid date format values are:
SYSFMT | QDATFMT |
|---|---|
DDMMYY | Day, Month and Year |
MMDDYY | Month, Day and Year |
YYMMDD | Year, Month and Day |
DDMMYYYY | Day, Month, Century and Year |
MMDDYYYY | Month, Day, Century and Year |
YYYYMMDD | Century, Year, Month and Day |
YYMM | Year and Month |
MMYY | Month and Year |
MMYYYY | Month, Century and Year |
YYYYMM | Century, Year and Month |
SYSFMT8 | QDATFMT including Century |
CYYMMDD | Century indicator, Year, Month and Day Century indicator, Year, Month and Day Note: The CYYMMDD format is only valid for a real column in LANSA for the IBM i in virtual column derivation. It can be defined in Visual LANSA, but not made operational. |