Now that I have my Sony RX100, I can get decent results at night. Amazing results actually, considering the size of the camera. Here are two samples of snapshots I took at night on the streets of Montreal.
RX100 ISO 320 10.4mm f/1.8 1/30 sec
RX100 ISO 6400 29.8mm f/4.5 1/80 sec