uid empid datetime 1 9003 2012-09-26 09:20:00 3 9000 2012-09-26 09:20:00 4 9004 2012-09-26 09:20:00 5 9002 2012-09-26 09:20:00 7 9001 2012-09-26 09:20:00 18 9004 2012-09-25 09:15:00 17 9000 2012-09-25 09:15:00 11 9004 2012-09-26 08:59:00 12 9002 2012-09-26 08:59:00 15 9003 2012-09-25 09:15:00 14 9001 2012-09-26 08:59:00 19 9002 2012-09-25 09:15:00 21 9001 2012-09-25 09:15:00
select * from attlog where TIME(datetime )>='09:00:00' and empid not in (select empid from attlog where TIME( datetime )<'09:00:00') AND DATE_FORMAT(DATE( datetime ) , '%m/%d/%Y' ) BETWEEN '09/25/2012' AND '09/26/2012'
uid empid datetime 1 9003 2012-09-26 09:20:00 3 9000 2012-09-26 09:20:00 17 9000 2012-09-25 09:15:00 15 9003 2012-09-25 09:15:00
uid empid datetime 1 9003 2012-09-26 09:20:00 3 9000 2012-09-26 09:20:00 18 9004 2012-09-25 09:15:00 17 9000 2012-09-25 09:15:00 15 9003 2012-09-25 09:15:00 19 9002 2012-09-25 09:15:00 21 9001 2012-09-25 09:15:00 22 9000 2012-09-25 09:15:00 23 9003 2012-09-25 09:15:00
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)