The AC night light needs to plug into a socket, while the DC night light use battery and can be used in anywhere you want.
Night light with day night sensor will only light up at night and auto-off at day time.
Night light with PIR motion sensor will only light up when motion detected.
Combine the day night sensor and PIR sensor together could save the energy at most.