mssql中得到当天数据的语句
时间:2021-02-13 11:11:53|栏目:MsSql|点击: 次
一条例子:
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
上一篇:sql server中批量插入与更新两种解决方案分享(存储过程)
栏 目:MsSql
本文标题:mssql中得到当天数据的语句
本文地址:http://www.codeinn.net/misctech/62184.html