USERID         CHECKTIME        CHECKTYPE            VERIFYCODE
=======================================================
3         10/03/2013 7:03:32 PM   I             1
3         10/03/2013 11:45:49 AM  I             1
3         10/03/2013 8:40:20 AM   I             1
3         11/03/2013 7:13:33 PM   I             1
3         11/03/2013 11:24:36 PM  I             1
3         11/03/2013 9:04:42 AM  I              1
4         10/03/2013 7:02:46 PM   I             1
4         10/03/2013 6:43:10 PM   I             1
4         10/03/2013 10:46:41 AM  I             1
4         10/03/2013 8:47:04 AM   I             1
4         11/03/2013 7:23:33 PM   I             1
4         11/03/2013 11:20:36 PM  I             1
4         11/03/2013 8:28:42 AM  I              1

10 March UserID(3) Maximum Time: 10/03/2013 7:03:32 PM
10 March UserID(3) Minimum Time: 10/03/2013 8:40:20 AM
11 March UserID(3) Maximum Time: 11/03/2013 7:13:33 PM
11 March UserID(3) Minimum Time: 11/03/2013 9:04:42 AM


10 March UserID(4) Maximum Time: 10/03/2013 7:02:46 PM
10 March UserID(4) Minimum Time: 10/03/2013 8:47:04 AM
11 March UserID(4) Maximum Time: 11/03/2013 11:20:36 PM
11 March UserID(4) Minimum Time: 11/03/2013 8:28:42 AM

USERID      |   DAY        |    INTIME(MINIMUM TIME)     | OUTTIME(MAXIMUM TIME)
=================================================================================
   3        | 10/03/2013   |        8:40:20 AM           |     7:03:32 PM
   3        | 11/03/2013   |        9:04:42 AM           |     7:13:33 PM

SELECT
  date(checktime) Day,
  time(min(checktime)) MinTime,
  time(max(checktime)) MaxTime
FROM t
WHERE userid = 3
GROUP BY Day