IS INGRESDATE Predicate
Use IS INGRESDATE to determine if a particular result can be assigned to a column of the given data type. It is especially useful for cleaning data or validating data input.
The IS INGRESDATE predicate takes the following form:
IS [NOT] INGRESDATE
For example:
SELECT 'date' IS INGRESDATE
is true if date is INGRESDATE in form.
If all values in a column pass this predicate, then the whole column can be coerced into an INGRESDATE column.
For example, the following returns "Invalid":
SELECT CASE WHEN 'abc' IS INGRESDATE THEN 'Valid' ELSE 'Invalid' END