select CONVERT(VARCHAR(11), cdate,0)as tourdate from Baiju.dbo.tyredetails
select convert(varchar(3),datename(month,cdate)) +'-'+ convert(varchar,day(cdate)) +'-'+ convert(varchar,year(cdate)) as tourdate from Baiju.dbo.tyredetails
Login to post response