In Godot I added a short FogVolume which covers the whole map, then modify its density at night.

DirectionalLight3D progressively changes intensity and colors at dawn and night, and back again to white at sunrise

I just added playtest build v0.22 for all you to try! Please have a look and let me know what you think.

Any feedback is welcome!