April 28, 2011

ISDATE in SQL Server

SELECT * FROM <TableName>
WHERE
ISDATE(FieldName) = 0

It will give all invalid date value from column.

Posted by Shatrughna Kumar at 12:52 AM
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)