Yes, you can stay in a short time hotel overnight.  All hotels have night rates as well as short time rates. But if you plan to stay overnight or longer, choose a guest-friendly hotel instead.