81,092
社区成员
发帖
与我相关
我的任务
分享
String startDate = "01/01/2010"; //in month/day/year format
String endDate = "04/01/2010"; //in month/day/year format
String roomNo = "1";
//lastdate must in month/day/year format
String sql = ”Select * from sys_pc "
+ "where ((CDate(lastdate) < ” + "#" + startDate + "# )"
+ " or (CDate(lastdate) > ” + "#" + endDate + "# ))"
+ " and room = '" + roomNo + "'"
select * from sys_pc where lastdate <= startdate or lastdate >=enddate and room=1
select t.lastdate,t.room from sys_pc t where t.lastdate < startdate
or t.lastdate > enddate and t.room=1