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
This question is related to
sql
sql-server-2005
You need to use convert in order by as well:
SELECT Convert(varchar,A.InsertDate,103) as Tran_Date
order by Convert(varchar,A.InsertDate,103)
Source: Stackoverflow.com