I have a table with a date column of datatype varchar(15) and the format is dd/mm/yyyy
When I write the following query, it displays complete data of the table and it cannot understand I want only between '01/08/2013' and '31/08/2013'
select date,column1,column2 from table1
where date between '01/08/2013' and '31/08/2013'
How to fix this? Appreciate your help.