How to Sorting rows in date wise in sql server 2005?

Prakash Mondal

12y2.9k

I want to sort multiple rows in date wise in sql server 2005..

First I create a table "StuInfo" and two attributes StuName, AdmissionDate their datatype are varchar2(20).

Then Insert multiple rows...

After Insert I try to sort inserted rows in date wise with assending order.

command is:

select *from StuInfo order by AdmissionDate desc;

but does not sorting properly....

Screen Shot bellow....

Then I try sort inserted rows in date wise with dessending order.

but does not sorting properly....

I want to sort.... assending/desending order that is (assending order):

Please Help me.

4 Replies

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

Satyapriya Nayak12y ago
SELECT
*
FROM StuInfo
ORDER BY CAST(AdmissionDate AS DATETIME)
0
Ravi Prakash12y ago
hello dear
This is Ravi Prakash
Your Question is you cant sort data by data Column
Your table structure is
create table stuinfo(
Roll int ,name nvarchar(50), date nvarchar(50)
)

When u execute query
select * from stuinfo order by desc
then query is execute according to data column but u column is nvarchar(50)

create table stuinfo(
Roll int ,name nvarchar(50), date datetime

)
the date part should be datetime
0
Khan Abrar Ahmed12y ago
Hi,please use
cast (AdmissionDate as date)
or convert(varchar,AdmissionDate,106)
0
Anupam Singh12y ago
Hi Prakash,

Because you are using varchar type for dates, it will not apply shorting as expected.
you should alter table and change this to DateTime. However you can use CONVERT function but I dont think will work with this format.
0