SQL Server:
select top 10 * from test where day(dateandtime)=day(getdate())
select * from test where datediff(d,day(dateandtime),day(getdate()))=0
select * from Attendance where convert(char(10),time,111)=convert(char(10),getdate(),111)
Access:
select top 10 * from test where day(dateandtime)=day(now())
test是表,dateandtime是日期/时间字段