SQL Server/T-SQL/Date Timezone/ISDATE

Evaluating Whether An Expression Is a Date or Is Numeric

   <source lang="sql">

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

---

         0

(1 rows affected)

</source>
   
  

SELECT ISDATE("1/1/2000")

   <source lang="sql">

3> 4> SELECT ISDATE("1/1/2000") 5> GO

---

         1

(1 rows affected)

</source>
   
  

select ISDATE("2002-09-30")

   <source lang="sql">

2> 3> select ISDATE("2002-09-30") 4> GO

---

         1

(1 rows affected) 1>

</source>
   
  

select ISDATE("2002-09-31")

   <source lang="sql">

3> select ISDATE("2002-09-31") 4> GO

---

         0

(1 rows affected)

</source>
   
  

select ISDATE("23:59:59")

   <source lang="sql">

2> select ISDATE("23:59:59") 3> GO

---

         1

(1 rows affected) 1>

</source>
   
  

select ISDATE("23:99:99")

   <source lang="sql">

3> select ISDATE("23:99:99") 4> GO

---

         0

(1 rows affected)

</source>