How to Convert Datetime to Date in dd MM yyyy format

Question

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

User · Answer

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

User · Answer

Give a different alias  SELECT  Convert varchar A InsertDate 103  as converted Tran Date from table as A order by A InsertDate

[sql] How to Convert Datetime to Date in dd/MM/yyyy format

Examples related to sql

Examples related to sql-server-2005