Cork ball will stay up forever and a day.
The more standard pop-ups it depends upon the brand. I've had Quest and Solar, I think, not staying popped up overnight if pierced. I actually trialled the Quest ones in a jug of water where stayed popped up for days, cast them into a lake and it was different.