• 网站程序如何读取一周之内的数据

    2010-12-24

    一周内的
    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