Do I need to keep the night mode on during the night?

No. The night mode is optional. You can even close the app and it will reappear on wakeup time.