Target Format

Mandatory.

Specify the desired date format to be used by the virtual column nominated in the 3.3.1 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

• If an alphanumeric date column (real or virtual) is being converted to a resulting numeric date column (real or virtual), a check will be automatically performed to ensure the resulting numeric date column contains all numeric characters (0 to 9). If the resulting numeric date column does not contain all numeric characters (i.e. alpha characters have been found) the resulting numeric date column will be set to 0.

Also See

Source Format