winmansoft (3/2/2013)

---

I have a query like

UPDATE a
SET oldRemarks1.modify('insert <Value_Py>{sql:column("b.collection_date")}</Value_Py>
after (/Root/Row[3]/Item)[1]') from b
where a.[Date]='31-May-2004' and a.sl_no=b.regkey_slno

Here collection_date is of datetime datatype.So while it is inserted to xml it will be like 2012-03-05T00:00:00.000 in the xml tag.But i want to insert it as just "2012-03-05" in the xml tag. So how can i use cast or any other method here so that it will insert properly in xml.

winmansoft (3/5/2013)

---

I can't change the datatype from datetime to date.So is there any method like cast or anything?