Can this light be set to automatically detect and light up only at night without having to manually turn the light off and on every day?

The motion activated solar floodlight has a photocell inside PIR sensor. It will not activate during the day. If the light is turning ON during the day it could be an indication of malfunction. If so, contact KODA support for a replacement unit, or return to the retailer of purchase.