如果是日期类型
declare @date datetime
set @date=getdate()
select * from Tbl_personlog where date>=DateAdd(day, DateDiff(day,0,@date), 0) and date < DateAdd(day, DateDiff(day,0,@date)+1, 0) 即可
如果是字符串格式,就怕格式不一致
格式一致的话(比较数据转换成一样格式)
select * from Tbl_personlog where date>=convert(varchar(10),@date,120) and date < convert(varchar(10),DateAdd(day, DateDiff(day,0,@date)+1, 0) ,120)
格式不一致就需要转化为时间(这个最糟糕,不能有效应用索引,效率最为低下)
select * from Tbl_personlog where cast(date as datetime)>=DateAdd(day, DateDiff(day,0,@date), 0) and date < DateAdd(day, DateDiff(day,0,@date)+1, 0)