The internet video that shows a mountain dew "flashlight" was a hoax. They simply used the solution found in glow sticks, which made it appear that adding simple household ingredients would cause it...
It depends on the paint used."Luminous" paint will only last a short time because it will lose its chemical reactants (radioactive paints being unusual)."Phosphorescent" paint may absorb light...