how to Sorting date based on month?

selva kumar

13y1.8k

hi friends this is my code....

select distinct convert(varchar,date,103)as date,convert(datetime,date,103)as date1 from [sample] order by date desc;

if i m using this...

i m getting two columns.....like this...

date1                               date
05-12-2013        2013-12-05 00:00:00.000
20-08-2013         2013-08-20 00:00:00.000
09-07-2013       2013-07-09 00:00:00.000
07-06-2013         2013-06-07 00:00:00.000
04-05-2013         2013-05-04 00:00:00.000
07-03-2013         2013-03-07 00:00:00.000
18-02-2013         2013-02-18 00:00:00.000
10-01-2013         2013-01-10 00:00:00.000

this is my problem...i want to display date1 column only without changing order....how do i get that date column....help me as soon as possible....

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

selva kumar13y ago
i have Found the answer...

this is my exact query...

select date1 from (select distinct convert(varchar,convert(datetime,date,105),103) as date1,convert(datetime,date,103)as date2 from [sample]) g order by convert(datetime,convert(varchar,date1,2),103) desc;
0
Shankar M13y ago
Hi Selva,

You can use this,

SELECT CONVERT(VARCHAR,GETDATE(),105)

Thanks, Shankar M
0
selva kumar13y ago
this not my answer .. i m asking for sql sever query....can u help me how to solve....
0
Tejas Patel13y ago
You can try this : string.Format("{0:dd/MM/yyyy}",
Example : string.Format("{0:dd/MM/yyyy}", datalist1.Rows[0]["date"])
0