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

Target Format