Turning the light off when you sleep has no bearing on the fish... but fish need to sleep too, so you need to have some dark time. It would also be a very poor decision to keep a light on 24/7, as algae would likely take over.
"What, exactly, is the internet? Basically it is a global network exchanging digitized data in such a way that any computer, anywhere, that is equipped with a device called a 'modem', can make a noise like a duck choking on a kazoo." - Dave Barry