Title: between date in sql server                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
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