As long as he is trained people leave their pets all day while they work but they are caged walk the pet before work and after work and again before your bed time and see that the pet has water but just not going is not healthy and it sounds like a problem for a vet......the best to you
About a day is the longest
Anything more than 10-12 hours is unhealthy.
It can go for a day with out it but shouldnt go more than that