Generally, it will be cooler at night. This will result in less evaporation of the water than during the wamer day. So, more water gets to soak into the ground.

So, it may be marginally better to water at night depending on the temperature difference day to night, and how much area you're going to water. The water savings is probably negligible if you're watering a small garden.

-Guru