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.