selvi subramanian

selvi subramanian

  • NA
  • 799
  • 571.6k

Need to save the date month year in sql server 2005

Apr 30 2015 6:11 AM
this is ,my query 


select *, convert(varchar(20), convert(varchar(2), day(date))+' ' +convert(varchar(3), datename(month, date))+' ' +convert(varchar(4), year(date))) as dat1 from partypaymentdetails
order by sectionname, month(date) ,day(date)


but it show the output like this



24/01/2015
22/01/2014

i need if 2014 details 1st then 2015 details next

Answers (5)