Night fiming is always going to be a problem with consumer digital camcorders as they just don't work well in low light conditions. This even includes situations such as under normal house lighting. As the cams get smaller, so does the lens which therefore lets less light in to be picked up by the CCD.
Many of the Sony cams have 'night modes' of different types. Some will give the 'black & green' picture you see with night vision scopes etc that is still very grainy and IMO not worth useing. I think there are other, better versions of night modes that can give an acceptable (according to those that have used them. I have not) picture.
I don't think you are ever going to get good night filming unless you can get very close and light the subject. To video at a distance in low light you are going to need to borrow the flood lights from your local football stadium

.
Some pointers that may help a little:
keep the zoom wide open as more light gets in this way.
If you have manual controls on the cam set the appature as wide as possible, slow down the shutter speed. Increasing the gain will help but will make the picture grainy.
Turn off any 'steady shot' feature
Use manual focus
Put the camcorder on a tripod.
I hope the above suggestions are of some help. If you give us some more details on what you are trying to video, and under the type of conditions then we may be able to give some more advise.
Mark.