It all depends on the dog.
Sierra is lazy and would hold it all day if I let her, but Buddy... ugh... if I let him, he'd go out and pee every half hour!
He's 3 1/2 and still wakes me up during the night a few times a week!
(he's sure got me trained!! )