How to Convert Datetime to Date in dd/MM/yyyy format
===

I want to write a query to get Date in dd/MM/yyyy format. (I do not want time).

So i wrote query like 

    SELECT	Convert(varchar,A.InsertDate,103) as Tran_Date
But when i write order by Tran_Date, it is giving me the result in wrong order.

Can some body please suggest what should i do.

Thanks