从accesse中取出当天的记录
表[Attendance]
=======================================
[Id] [PassportId] [Time]
1 1 2005-06-20 7:53:00
2 2 2005-06-21 10:06:26
3 4 2005-06-21 10:07:48
[解决办法]
SELECT * FROM TT WHERE FORMAT([TIME], 'YYYY-MM-DD ')=FORMAT(DATE() 'YYYY-MM-DD ')
[解决办法]
SELECT * FROM TT WHERE FORMAT([TIME], 'YYYY-MM-DD ')=FORMAT(DATE() 'YYYY-MM-DD ')
--或
SELECT *
FROM 表名
WHERE [Time] > = date() and [Time] < Date()+1
