Target Format

Mandatory.

Specify the desired date format to be used by the virtual column nominated in the Virtual Column Name.

This is the date format that the virtual column is converting to.

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

 

 

Warning

Also See

Source Format