selvi subramanian

selvi subramanian

  • NA
  • 799
  • 572.5k

need to change the month format in sql server

May 2 2015 2:54 AM
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 


Answers (1)