All 5 at our house sleep through the night.
weekdays 9 pm to 6 am
weekends 10 pm to what ever time we wake up usually between 8:30 and 9:00 am
We love to sleep in on weekends - "Thank God" so do our furbabies LOL
My 16 year old has 2 yorkies and they don't get up until she does. Sometimes she sleeps in on weekends until 12

I usually will go and take them out because I think that's way too long for them to hold it. Right after I take them out they run back into her room to keep sleeping.