I have a sql database with date in the format
I have the following select statement
select * from database where date >= 1/5/2008 and date <= 7/3/2011
which is in the format dd/mm/yyyy
I am however getting dates in 2006 in my result.
How do i convert the date in the database to same format?