Select Query for Dates
EmpID,Name,PermissionDateFrom,PermissionDateTo,PermissionHours1,TestUser,01-01-2014,07-02-2014,01:00 Hrs
From the above table content, I need to write a query that TestUser have permission the date 10-01-2014.
The Dates from jan 1 to Feb 7. So 10th of jan is between the dates.
I give input as 10Jan, it should fetch the above row. so i can get the 01:00 Hrs of permission as result.