请问一个select语句

[vicqqq]

表：
RDate nvarchar(50)
Content Text

RDate Content
past fjslkdjfklsjdf
2008-08-08 sldjfljasdf
intrans jksjfkljsdf
2008-08-10 fjlksdjfl
... ....
选择RDate是日期类型且比今天日期大的数据
我这样写
select * from table where isdate(Rdate)=1 and datediff(dd,getdate(),Cast(RDate as datetime))>0
总是出错Conversion failed when converting datetime from character string.

[paoluo]

try


Select * From(
select * from [table] where isdate(Rdate)=1) A Where datediff(dd,getdate(),Cast(RDate as datetime))>0

[mugua604]

intrans 这种记录不能转换为DATETIME

[vicqqq]

还是这种错误哦

[vicqqq]

那该怎么做

[songq]

RDate字段里边有past这样的数据，你在select中将RDate转换成日期型的，当然报错了

[paoluo]

用了子查詢也會報錯？!

[Limpire]

select * from table where isdate(Rdate)=1 and RDate > convert(nvarchar(10), getdate(), 120)

[vicqqq]

是啊，怎么办，楼上的还是报错啊

[Limpire]

-- OR

select a.*
from (select * from table where isdate(Rdate)=1) a
where datediff(dd,getdate(),Cast(a.RDate as datetime))>0

[vicqqq]

还是Conversion failed when converting datetime from character string.
我用临时表做就没错

[paoluo]

vicqqq(大奶妹 (. 人 .)) ( ) 信誉：100 2007-08-09 15:40:05 得分: 0


还是Conversion failed when converting datetime from character string.
我用临时表做就没错


-----------
用子查詢的確不行。

實在不行，就用臨時表做了。

[vicqqq]

就是想用一条语句搞定