Newb question, how long.

Due to my always smoking before going to sleep, I often left bowls sitting overnight to be finished the next morning. I found no significant deterioration of flavour. However, I would not leave the bowl uncleaned for too long as your pipe will need to breathe rather sooner than later in order to dry out, particularly if you have a small rotation. A sour pipe tastes awful and is difficult to remedy.