UPDATE pxy_abstract_message SET messagereceived =decode(replace(encode(messagereceived, 'escape'), 'tmp', substr(encode(messagereceived, 'escape'),14,4 ) || '/' || substr(encode(messagereceived, 'escape'),18,2 ) || '/' || substr(encode(messagereceived, 'escape'),20,2 )),'escape') where pxy_abstract_message_type = 'DicomMessage';
