How long will an open bottle of red wine stay fresh?

Minutes, probably. Red wine should not be left unopened. The wine continues to oxydize. It should be sealed if not finished.