Question

现在需要改变SQL查询条件，怎么修改

修改条件select * from detailsrecord where (detailsrecord.date>20160229 and detailsrecord.date<=20160311） OR（detailsrecord.date=20160229 and detailsrecord.time>=time("02:09:23")) OR (detailsrecord.date=20160311 and detailsrecord.time<=time("07:19:44"))怎么修改进去

Answer 1

看不清截图里的语句。

追问

追答

那你把SQL.format(* SQL语句 *) 替换就可以了，把原来的 select * from detailsrecord 加上 where (detailsrecord.date>20160229 and detailsrecord.date=time("02:09:23")) OR (detailsrecord.date=20160311 and detailsrecord.time<=time("07:19:44")) 加上原来的order by ...

追问

为什么detailsrecord.time>=time("02:09:23")会报错，02的位置显示应输入“）”

追答

detailsrecord.time>=time("02:09:23")
就SQL语句来说，这个是应该不对的，应该是 detailsrecord.time>=‘02:09:23’这样才对