sql 查询当天记录
SQL Server:
select top 10 * from test where day(dateandtime)=day(getdate())
select * from test where datediff(d,day(dateandtime),day(getdate()))=0
Access:
select top 10 * from test where day(dateandtime)=day(now())test是表,dateandtime是日期/时间字段