select * from VerificationTable where VerificationStarTime>='2008-07-22' and VerificationStarTime<='2011-12-08 23:59:59'错误:
消息 241,级别 16,状态 1,第 1 行
从字符串转换日期和/或时间时,转换失败。
咋会这样呢?? 求解救
消息 241,级别 16,状态 1,第 1 行
从字符串转换日期和/或时间时,转换失败。
咋会这样呢?? 求解救
调试欢乐多
where VerificationStarTime>='2008-07-22'
and VerificationStarTime<='2011-12-08 23:59:59' --把全角的:换成半角
where cast(VerificationStarTime as datetime)>='2008-07-22 00:00:000'
and cast(VerificationStarTime as datetime)<='2011-12-08 23:59:599'[/code]
where cast(VerificationStarTime as datetime)>='2008-07-22 00:00:000'
and cast(VerificationStarTime as datetime)<='2011-12-08 23:59:599