What an odd phrase, “one night stand”.

If you mean that you're standing for a whole night, that's a really long time, my feet ache just thinking about it!

If you mean that you're going to take a stand on something, that's a very short time, you're not really making much of a statement, now are you?