There is a good reason why you should avoid wearing moisturisers or foundations with sun protection during the night. Products containing sun protection use ingredients such as zinc oxide and titanium dioxide which are opaque, white pigments, which reflect and scatter light rays. This is the last thing you want to happen when you are taking photos.
The combination of a camera flash and white pigments from the sun protection can make your complexion look white, lifeless and pasty. The end result is having photos with your face paler than the rest of your body.
Be mindful of foundations that contain sunscreen. Be careful of mineral makeup as it is full of zinc oxide and titanium dioxide.