Any camera should manage it, but you need to be careful with the exposure.
Most cameras default to giving the best exposure for the whole image so if it's mostly a dark sky with a bright moon in it, the camera will try to expose correctly for the sky and since that's (practically) black, the moon will end up over-exposed as a result.
Result: an over-bright streetlight.
If your camera can have "spot" exposure mode selected (the default is usually called "matrix" or "area"), then it would attempt to correctly expose only what's right in the centre of the viewfinder and if that was the (relatively) evenly lit moon, then it would be exposed Ok. The advantage now is that the darker sky would be under-exposed so you'd also get a nice, dark background.
Result: a picture of the moon.
_________________
Giraffe: a ruminant with a view.