mssql中得到当天数据的语句
发布时间:2016-12-29 来源:查字典编辑
摘要:一条例子:selectcount(point_id)astoday_sumfrompointwheredatediff(d,point_da...
一条例子:
selectcount(point_id)astoday_sumfrompointwheredatediff(d,point_date,getdate())=0
关键语句:
datediff(d,point_date,getdate())=0