博客展示了两段SQL查询代码，用于从名为rizhi的表中筛选数据。第一段代码根据特定用户和时间范围查询，时间范围由起始时间计算得出；第二段代码根据用户输入的时间范围查询，并按rz_ID降序排列结果。
time1=#2004-10-10#
time2=DateAdd("d",1,time1)
time3="#" & time1 & "#"
time4="#" & time2 & "#"
"SELECT * FROM rizhi WHERE rz_employee = 'user' and time between " & time3 & " and " & time4
time2 = request("to")
tempdate = CDate(time2)
tempdate2 = DateAdd("d",1,tempdate)
time2 = "#" & time2 & "#"
end_time = "#" & tempdate2 & "#"
"SELECT * FROM rizhi WHERE rz_time between " + time2 + " and " + end_time + " ORDER BY rz_ID DESC"
time2=DateAdd("d",1,time1)
time3="#" & time1 & "#"
time4="#" & time2 & "#"
"SELECT * FROM rizhi WHERE rz_employee = 'user' and time between " & time3 & " and " & time4
time2 = request("to")
tempdate = CDate(time2)
tempdate2 = DateAdd("d",1,tempdate)
time2 = "#" & time2 & "#"
end_time = "#" & tempdate2 & "#"
"SELECT * FROM rizhi WHERE rz_time between " + time2 + " and " + end_time + " ORDER BY rz_ID DESC"
扫一扫
728
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
