yes i have tried between keyword but its not working because i want to filter only month & year. if full date is given then no problem but when i give only month and year, it is retieving records but they are not in range. i have also tried month(), year() and date_format() functions.
my sql is like follow:
select date_format(purchasedate,'%d-%M-%Y') from purchase
where date_format(purchasedate,'%m-%y') between "05-2010" and "08-2011"