It does not seem to make a difference if its day or night as even when its day the street lights that give off light when it gets dark look slightly different and when shot out go slightly darker, showing that the light is broken and I have seen improvements on both day and night when destroying even a few street lights.
So far only tested on KotH servers but since afaik the map itself is the same it applies to all servers, game modes and perhaps even singleplayer as long as there are street lights around.