Leaving batteries connected during long term camping

On another site I read a thread about unhooking the batteries when running on 120 volt for an extended time to prevent over heating. My question is how long is long term? Two nights? A week? A month? ...