Loading

need to change the month format in sql server

selvi subramanian

11y890

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khargesh Rajput11y ago
select partyid, convert(varchar(20), convert(varchar(2), day(date))+' '
+convert(varchar(10), datepart(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)