Code snippet for updating specific data in xml column in mssql
declare @date datetime
set @date = GETDATE()
UPDATE XmlDocuments
SET xmlmetadata.modify ('replace value of (/Header/Date/text())[1] with sql:variable("@date")')
WHERE ID = '1000001'