It varies by hotel.
I currently have 8 reservations with day of arrival, 5 reservations with 1 day prior to arrival, 2 reservations with 2 days prior to arrival, and 1 reservation with 3 days prior to arrival. This is indicative of past experiences over the past 15+ years.