ISDATE( string )

INT

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

This function supports NCHAR inputs and/or outputs.

• CURRENT TIME special value
• CURRENT TIMESTAMP special value
• CURRENT UTC TIMESTAMP special value
• DATE data type
• DATE function [Date and time]
• DATETIME data type
• DATETIME function [Date and time]
• DATETIMEOFFSET data type
• Expressions
• GETDATE function [Date and time]
• NOW function [Date and time]
• SMALLDATETIME data type
• TIME data type
• TIMESTAMP special value
• TIMESTAMP data type
• UTC TIMESTAMP special value

The following example imports data from an external file, exports rows which contain invalid values, and copies the remaining rows to a permanent table.

CREATE GLOBAL TEMPORARY TABLE MyData(
      person VARCHAR(100),
      birth_date VARCHAR(30),
      height_in_cms VARCHAR(10)
   ) ON COMMIT PRESERVE ROWS;
   LOAD TABLE MyData FROM 'exported.dat';
   UNLOAD
      SELECT * FROM MyData
      WHERE ISDATE( birth_date ) = 0
  OR ISNUMERIC( height_in_cms ) = 0
   TO 'badrows.dat';
   INSERT INTO PermData
      SELECT person, birth_date, height_in_cms
      FROM MyData
      WHERE ISDATE( birth_date ) = 1
  AND ISNUMERIC( height_in_cms ) = 1;
   COMMIT;
   DROP TABLE MyData;