sql tarih formatlama
select LEFT(tarih,2), SUBSTRING(tarih,4,2),SUBSTRING(tarih,7,4),* from tbl_arananlar
where SUBSTRING(tarih,7,4)+SUBSTRING(tarih,4,2)+LEFT(tarih,2) between '20100919' AND '20101020'
select LEFT(tarih,2), SUBSTRING(tarih,4,2),SUBSTRING(tarih,7,4),* from tbl_arananlar
where SUBSTRING(tarih,7,4)+SUBSTRING(tarih,4,2)+LEFT(tarih,2) between '20100919' AND '20101020'