...
PARSE-AS-DATETIME is more restrictive than PARSE-AS-SIMPLEDATE. The format strings for PARSE-AS-DATE DATETIME must exactly match the input strings. If they do not match, an error occurs. For more information, see “Troubleshooting” in FORMAT-DATETIME.
If the column is null
or is already a datetime field, applying this directive is a no-op. The column to be parsed as a datetime should must be of type string.
Format String Examples
...