I only have the aquarium lights on when i am in the room viewing the fish, at all other times the tanks are lit by the room light only.
As long as there is some kind of light in the room whether it be sunlight from a window or artificial light from lamps the fish will be aware of the difference between night and day. Very few natural aquatic habitats have the same volumes of bright lighting that a aquarium has as overhanging foliage and floating aquatic plants will filter out a large majority of the sunlight.