ISDATE Function

Determines whether the specified value is a text string that can be parsed into a date/time with or without a time zone offset.

Syntax

ISDATE(value)

Parameters

• value: scalar
  The value to inspect.

Return Value

Returns 1 if value is a valid date/time string, and returns 0 if not.

Example

PRINT ISDATE('2016-03-07');  -- "1"
PRINT ISDATE(1234);  -- "0"
PRINT ISDATE('foo');  -- "0"
PRINT ISDATE('2016-01-23 22:06:53.742 -04:00');  -- "1"