網(wǎng)站程序如何讀取一周之內(nèi)的數(shù)據(jù)
2010-12-24
一周內(nèi)的
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