UPDATE {databaseOwner}{objectQualifier}DMX_EntryAttributes
SET [Value]=LEFT([VALUE],19)
WHERE AttributeId IN
 (SELECT AttributeId FROM {databaseOwner}{objectQualifier}DMX_Attributes
  WHERE ValueType='Date')
GO
