mercredi 21 janvier 2015

Order By not working on datetime 101 format


Create table #temp
(
OrderDate datetime
)

insert into #temp values ('01/21/2015'),('01/20/2014'),('11/12/2013')

select distinct convert(varchar(10),orderdate,101) as OrderDate from #temp
order by convert(varchar(10),orderdate,101) asc


The above query gives me the result like below:



OrderDate
01/20/2014
01/21/2015
11/12/2013


But I want the result like below:



OrderDate
11/12/2013
01/20/2014
01/21/2015


The above is just a sample on which I am trying to do sorting on format 101. In my actual query I need to use distinct keyword and also the columns will come dynamically in the select statement by using parameter.


I can't use group by in my actual query.


Please help.


Aucun commentaire:

Enregistrer un commentaire