The original question was not clear, what is the meaning of night usage? and I am assuming you only want Point and Shoot camera.
To take long exposure shots? You need camera with Manual mode and tripot
To take shots in low light and don't want to use flash light: You need high speed lense (Panasonic FZ series with constant F2.8), and low noise at high ISO setting (Example Fuji F-10).
You don't mind using flash, but when it is too dark it is very difficult to frame the object, some P&S camera, does not have optical view finder (they only have EVF), you can't frame and focus the object: Minimum you need P&S camera with optical view finder because human eyes has better low light sensitivities and also AF assist. The best camera for such situation are Sony F717, V1: These camera have very special feature call night framing.
In night framing mode, the camera flip up the infra-red filter and turn on the infra-red light, to help you do the picture framing, when pressing the shutter button, it go back to normal mode and the AF assist light turn on to help focusing, finally the camera take the picture with flash light and you get excellence picture: Good framing, good Focus and bright picture. Both Sony models are having hot shoe to house a more powerful external flash.
These are the cameras I am currently having: Fuji 602Z, Sony V1, Panasonic FZ1, (owned FZ10 before and sold away), Canon A40, Minolta X20, Nikon D70 and D50.
All of them have unique features that suits difference situation. But off course the DSLR will be able to handle all situations with various kind of lenses. However each DSLR lense is the price of one P&S camera.
Fuji 602 is very fast response camera, low noise up to ISO400, but hard to frame and focus at low light.
Sony V1 is small size, with Night framing and night shot mode, but battery life sucks.
Pana FZ1 has the best lens, again it is bad for low light shotting (hard to frame and focus)
Minolta X20 is very handly and small, the best feature about it is using 2 AA battery, that you can buy battery from every where when running out of joice.
Nikon D70/50 are good but too big to carry around.
