It seems like if you wanted to do this accurately, you'd need to lock exposure to handle a bright blue sky without blowing out -- both aperture and shutter speed. And lock white balance. The question is whether that would allow for sufficient sensitivity at night. But if you're just averaging color values across a section of sky and mainly looking for moon and moonlit clouds, I think it would, since pixel noise will get averaged out and the moon is bright.