I had to insert the current datetime in a piece of XML which was stored in a Transact-SQL xml datafield. But the XQuery in Transact-SQL doens’t support ‘fn:current-dateTime()’. So we had to devise another solution.