HI,
I have stored data & time as varchar type and data looks like this **"9/16/2010 2:59:10 PM"**.
Now I want to retrieve data from between two dates such as From 01/01/2010 to 31/10/2010, When I run this SQL Statement:

```
SELECT     username, timein, timeout
FROM         user_log
WHERE     (timein BETWEEN '01/01/2010' AND '30/11/2010')

```

It returns me nothing. So How should I resolve this.
Thanks.