一周内的
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())<=7"
昨天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=1"
今天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=0
一周内的
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())<=7"
昨天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=1"
今天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=0
评论列表: