If I want the year and month I would need to add the right and left.  correct

UPDATE [EC_StoreAttributes]

  SET AttributeValue = RIGHT(CONVERT(VARCHAR(10), GETDATE(), 101), 2) +
   SUBSTRING(AttributeValue, 3, LEN(AttributeValue) - 4) +
   left(CONVERT(VARCHAR(10), GETDATE(), 101), 2)

WHERE
AttributeType = 'ECSRCCODE' and StoreRecordId = '1'