select roomid
from room
where ((isdate(endtime)
and cast(endtime as datetime)<dateadd('d',4,getdate()))
and shengli=0
from room
where ((isdate(endtime)
and cast(endtime as datetime)<dateadd('d',4,getdate()))
and shengli=0
from room
where ((isdate(endtime)
and cast(endtime as datetime)<dateadd('d',4,getdate()))
and shengli=0
from room
where ((isdate(endtime)=1
and cast(endtime as datetime)<dateadd('d',4,getdate()))
and shengli=0
from room
where ((isdate(endtime)=1 --等于1说明是有效日期,0为无效日期
and cast(endtime as datetime)<dateadd('d',4,getdate()))
and shengli=0
:(
我没仔细看你的语句,拷贝下来的,你的语句里多一个括号,会有错,另dateadd里第一参数不加引号就行了select roomid
from room
where ( isdate(endtime)=1 --等于1说明是有效日期,0为无效日期
and cast(endtime as datetime)<dateadd(d,4,getdate()) )
and shengli=0
已经解决了,听你的解答令人有一种毛厕洞开的快感:)