Evaluating Whether An Expression Is a Date or Is Numeric : ISDATE « Date Timezone « SQL Server / T-SQL






Evaluating Whether An Expression Is a Date or Is Numeric

 

3>
4>
5> SELECT ISDATE('1/1/20000')
6> GO

-----------
          0

(1 rows affected)

 








Related examples in the same category

1.SELECT ISDATE('1/1/2000')
2.select ISDATE('2002-09-30')
3.select ISDATE('2002-09-31')
4.select ISDATE('23:59:59')
5.select ISDATE('23:99:99')