SELECT USERID, CONVERT(nvarchar(11), LOCALTIMESTAMP, 105) AS dates, CONVERT(nvarchar(11), LOCALTIMESTAMP, 131) AS hijri, DATENAME(WEEKDAY, LOCALTIMESTAMP) AS myday,
MIN(CASE WHEN [EVENTID] = `IN` THEN substring(CONVERT(VARCHAR, LOCALTIMESTAMP, 114), 1, 5) END) AS min_in, MAX(CASE WHEN [EVENTID] = `OUT` THEN substring(CONVERT(VARCHAR,
LOCALTIMESTAMP, 114), 1, 5) END) AS max_out
FROM access_event_logs
WHERE (LOCALTIMESTAMP >= CONVERT(datetime, `10-02-2014`, 105)) AND (LOCALTIMESTAMP < CONVERT(datetime, `21-02-2014`, 105)) AND (USERID = `999`)
GROUP BY USERID, CONVERT(nvarchar(11), LOCALTIMESTAMP, 105), CONVERT(nvarchar(10), LOCALTIMESTAMP, 120), CONVERT(nvarchar(11), LOCALTIMESTAMP, 131), DATENAME(WEEKDAY, LOCALTIMESTAMP)
ORDER BY CONVERT(nvarchar(10), LOCALTIMESTAMP, 120) DESC