计算两个时间段内的记录

最新推荐文章于 2022-11-10 16:32:49 发布

lbh9158

最新推荐文章于 2022-11-10 16:32:49 发布

阅读量955

点赞数

分类专栏： DataBase 文章标签： sql table date

DataBase 专栏收录该内容

16 篇文章

订阅专栏

sql="select id,classid,classname,xiaoshoue,xiaoshou,jinhuo,kucun,addtime "
sql=sql&" from xiaoshou where addtime between '" & format(starttime,"yyyy-mm-dd") & "' and '" & format(endtime,"yyyy-mm-dd") & "'"
sql=sql&" order by id desc"

Select Fylb,Pm,Gg,Dw,Dj,Sl,Je FROM cqyzypzx where zxdate between {^2003-7-1}and {^2003-8-1}

近两个星期
sql="select * from table where datediff(week,riqi,getdate())<=2"

近三个月
sql="select * from table where datediff(month,riqi,getdate())<=3"

近一年
sql="select * from table where datediff(year,riqi,getdate())<=1"

Apply_Date between #"& startdate &" 23:59:59# and #"& enddate &" 23:59:59#"