mssql中得到当天数据的语句
编程学习 2021-07-05 13:42www.dzhlxh.cn编程入门
一条例子:
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