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'