Search This Blog

ISDATE() TSQL Return Value

Column value (varchar) ISDATE return value

NULL

0

Abc

0

100, -100, 100 a, or 100.00

0

.01

0

-100.1234e-123

0

.231e90

0

$100.12345, - $100.12345, or $-1000.123

0

as100 or 1a00

0

1995-10-1, 1/20/95, 1995-10-1 12:00pm, Feb 7 1995 11:00pm, 1995-10-1, or 1/23/95

1

13/43/3425 or 1995-10-1a

0

$1000, $100, or $100 a

0