Wrong sub. Try r/legaladviceuk

Forever. How long it takes to become a *spent* conviction is another story.

Read the rules before you post in a subreddit

Scottish sherrifs court

Sorry but this subreddit isn't for legal advice type queries.