sql时间查询的问题,

[a496335005]

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

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


咋会这样呢?? 求解救

[Shawn]

select * from VerificationTable  
where VerificationStarTime>='2008-07-22' 
and VerificationStarTime<='2011-12-08 23：59：59' --把全角的:换成半角

[a496335005]

[Quote=引用 1 楼 wwwwgou 的回复:]

SQL code
select * from VerificationTable
where VerificationStarTime>='2008-07-22'
and VerificationStarTime<='2011-12-08 23：59：59' --把全角的:换成半角
[/Quote]

跟全角半角没有关系

[勿勿]

VerificationStarTime 这个是什么格式啊

[a496335005]

[Quote=引用 3 楼 szstephenzhou 的回复:]

VerificationStarTime 这个是什么格式啊
[/Quote]
datetime

[--小F--]

[code=SQL]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'

[/code]

[--小F--]

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