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 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.

Also See