ISDATE function [Data type conversion]

Tests if a string argument can be converted to a date.

Syntax
ISDATE( string )
Parameters
  • string   The string to be analyzed to determine if the string represents a valid date.

Returns

INT

Remarks

If a conversion is possible, the function returns 1; otherwise, 0 is returned. If the argument is NULL, 0 is returned.

Standards and compatibility
  • SQL/2003   Vendor extension.