导读:一条例子: selectcount(point_id)astoday_sumfrompointwheredatediff(d,point_date,getdate())=0 关键语句: datedif..
一条例子:
select count(point_id) as today_sum from point where datediff(d,point_date,getdate())=0
关键语句:
datediff(d,point_date,getdate())=0
select count(point_id) as today_sum from point where datediff(d,point_date,getdate())=0
关键语句:
datediff(d,point_date,getdate())=0
更多文章请关注《万象专栏》
转载请注明出处:https://www.wanxiangsucai.com/read/cv149284
话题推荐: #mssql中得到当天数据的语句#