order by date query

Question

hi can any1 tell solution for this Select schoolmaster.Name from schoolmaster order by birthDate desc o/p i am getting in this order: 01/05/2010 02/05/2010 09/03/2010 30/04/2010 but i need in following way. 09/03/2010 30/04/2010 01/05/2010 02/05/2010 Any idea for doing this in database i have birthDate as Text field.

Crish · Answer

hi have you used birthdate as nvarchar or anything else ? . becuase my side its working fine with nvarchar datatype.

yashvant k · Answer

if i use asc then also it wont saw proper o/p. I cant chage field to datetime property for it.

Dipa Ahuja · Answer

why you take birthdata as text.. i think you wont get proper out put because its data type is text you have to take birthdate as date/time and in result you want ascending order then no need to write desc..

Crish · Answer

hi please use below query Select schoolmaster.Name from schoolmaster order by birthDate asc If you have taken birthDate as Texttype then you need to convert it datetime and then you can sort it. thanks