Depending on the type and quality of the product used. Body paint lasts anywhere between a few hours and a day. Henna lasts even longer for about two weeks if cared for and protected.
On the other hand, alcohol-based body paints last up to 3 days, while water-based ones won’t survive overnight as rubbing against sheets and sweat removes most of the pigment. Glitter tattoos go up to a week if you take good care of them.