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.

...

• 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