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>