Actian Ingres 12.1 | IS DATE/IS ANSIDATE Predicate

SQL Reference Guide > Understanding the Elements of SQL Statements > Predicates in SQL > IS DATE/IS ANSIDATE Predicate

Was this helpful?

IS DATE/IS ANSIDATE Predicate

Note: IS DATE is an alias to IS ANSIDATE.

Use IS DATE to determine if a result can be assigned to a column of the given data type. It is especially useful for cleaning data or validating data input. When applied to row value expressions, all elements must test the same.

The IS DATE predicate takes the following form:

IS [NOT] DATE/ANSIDATE

The following is the input and output of the IS DATE predicate:

Data Type of Input Expression	Output
NULL (of any data type)	Null
DATE	True
CHAR/VARCHAR	True/False as per the II_DATE_FORMAT for Absolute Ingresdate setting
All other data types	False

Examples:

isdate(null('2010-10-10'))

is Null.

isdate(date('2020-10-10'))

is True since the input expression is a valid date value.

isdate('2010-10-20')

is True as the input expression is a valid date in format yyyy-mm-dd

while

isdate('2010-20-10')

is False as the input expression is not a valid date format.

isdate(int('20201010'))

is False as other data types are not supported.

Last modified date: 01/27/2026