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是日期/时间字段