need to change the month format in sql server
select partyid, convert(varchar(20), convert(varchar(2), day(date))+' '
+convert(varchar(10), datename(month, date))+' ' +convert(varchar(4), year(date)))
as dat1 from partypaymentdetails where sectionname='Owner'
and partyname='celv' order by sectionname, YEAR(date) asc , month(date) ,day(date)
am getting output like this
20/jan/2015
but my need is 20/01/2015