Need to save the date month year in sql server 2005

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 year(date)

try this order by year(date)



if this solve ur problem "Mark as Answer"   thnx

only use order by date