There are rules about you needing to declare it for certain jobs and the time for that varies depending on your sentence, but the police will always have the details
It will appear on an enhanced CRB check for ever .
A conviction will become 'spent' and not need to be declared after a set time.
This time depends on the sentence given.
How ever as I said even a 'spent' conviction will appear on an enhanced CRB check.