How to convert date and time in dd / MM / yyyy format

Question

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

So, I wrote a query like

SELECT Convert(varchar,A.InsertDate,103) as Tran_Date 

But when I write the order by Tran_Date, it gives me the result in the wrong order.

Can any body suggest what I should do.

thanks

Answer 1

Give another alias

 SELECT Convert(varchar,A.InsertDate,103) as converted_Tran_Date from table as A order by A.InsertDate 

Answer 2

You should also use the conversion in order:

 SELECT Convert(varchar,A.InsertDate,103) as Tran_Date order by Convert(varchar,A.InsertDate,103)