How long does the effects of a cortisone shot last?

[aussie]

Hi guys went to my Doc today after having some xrays --he said my hips look good but im still in alot of pain in my right side---he asked if i wanted to try cortisone shot i said why not--he also said there inflamation around it and by having the shot it will frree up my joint

Has anyone had and luck with them