That's one of those issues that people will argue for both sides. Overall, I don't think it makes a big difference, unless you have a hurricane going on in your tank during the day. Afterall, the ocean doesn't stop moving just because the sun went down. I would also think that if you have a reef tank, you would want to keep the water well circulated as many corals feed at night.