sql时间查询的有关问题

2012-01-15

sql时间查询的问题,SQL codeselect * from VerificationTablewhere VerificationStarTime2008-07-22 a

sql时间查询的问题,

SQL code

select * from VerificationTable  where VerificationStarTime>='2008-07-22' and VerificationStarTime<='2011-12-08 23：59：59'

错误:
消息 241，级别 16，状态 1，第 1 行
从字符串转换日期和/或时间时，转换失败。

咋会这样呢?? 求解救

[解决办法]

SQL code

select * from VerificationTable  where cast(VerificationStarTime as datetime)>='2008-07-22 00:00:000' and cast(VerificationStarTime as datetime)<='2011-12-08 23:59:599

热点排行

Bad Request.

SQL Server

sql时间查询的有关问题