[sqlite] formating yyyymmdd dates

[DuenosEnLaWEB.com.ar]

hi

I have this format for dates: yyyymmdd
I want this format to be returned from a query: dd/mm/yyyy

The only way i have found is doing this... but i do not like it very =
much

SELECT =
strftime('%d/%m/%Y',substr('20050605',1,4)||'-'||substr('20050605',5,2)||=
'-'||substr('20050605',7,2));

is there a better way to get it?

thanks