CONVERT() Function

[NICE TO MEET]

i want a datetime format as mm/dd/yyyy in dataset i am getting AcquisitionDate="2005-05-05T00:00:00+05:30" if i used convert(datetime,AcquisitionDate) function ,the sql is throwing error convertion failed to datetime as character string any other way to convert this guide me please -

[vivek g]

It is too simple.. try this out... --> convert(char,getdate(),101) <--function .... vivek