Sqlquery for retrive data between two dates

You have to put quotes around date values :

select USERID,checktime from CHECKINOUT where((CHECKTIME between '2012/06/01' and '2012/06/30'))order by CHECKTIME asc

To be more portable use '-' instead of '/' as some databases don't like '/' :

select USERID,checktime from CHECKINOUT where((CHECKTIME between '2012-06-01' and '2012-06-30'))order by CHECKTIME asc

Bigyan,

First question, are there data between the date range?

It looks like there's a typo in your till date, you're missing a /

Besides, there is no need for the braces.

SELECT USERID,checktime FROM CHECKINOUT WHERE CHECKTIME BETWEEN '2012/06/01' AND '2012/06/30' ORDER BY CHECKTIME ASC

Try this and let us know!