请问这条SQL 语句对吗?如果不对要怎么写?

发布网友发布时间：2022-04-10 23:32

共4个回答

热心网友时间：2022-04-11 01:01

Strscl="select id,title,sd,od from [news] where datediff(day,sd,'"&now()&"')>=0 and datediff(day,od,'"&now()&"')<0 order by state desc,ID desc"

如果到期不包括当天日期就用datediff(day,od,'"&now()&"')<0
如果包括就用datediff(day,od,'"&now()&"')<=0

热心网友时间：2022-04-11 02:19

Strscl="select id,title,sd,od from [news] where datediff("d",sd,now())>=0 order by ID desc"

过期时间是多少，是一个星期，还是一个月？

测试通过

热心网友时间：2022-04-11 03:54

Strscl="select id,title,sd,od from [news] where datediff('d',sd,'"&now()&"')>=0 order by ID desc"

热心网友时间：2022-04-11 05:45

Strscl="select id,title,sd,od from [news] where datediff(""d"",sd,"&now()&")>=0 and datediff(""d"",od,"&now()&")<=0 order by ID desc"