I apologize if this question has been answered before. What would be the best setting on the D3100 for shooting yellow street lights at night? I haven't gotten the camera just yet but there're specific places I'd like to explore with the camera at different times of the day (sunset, midday, dawn, twilight, night). These are places I can't just be at at any given time so the moments. If I'm lucky enough to be there I'd like to make the most out of my photographs.
You'll also want to shoot at small apertures because this makes the light sources look like bursts, but this means that you'll need a tripod since it will likely be a long exposure.
You'll get the best look, as @ohyeahar suggests, with relatively small apertures and probably with low ISO speeds too, so you'll definitely benefit from a tripod. You can grab almost anything at high ISO, but the higher settings will be noisy and less sharp. This will be especially visible in very dark underexposed areas, the very thing you're looking for at night.
Live view on a tripod can be useful because you compose from a little distance, and also because stray light through the viewfinder (a small but real issue in viewfinder mode) is not an issue in live view.
Remember though that the live view is exposure corrected for the display only. What you see does not reflect your exposure settings. If you're wrong, it will be wrong even if the display looked good, and if you have a specific exposure compensation in mind, you will not see it.
If you're hand holding without a tripod, you may find that viewfinder mode works better than live view. I find live view hard to hold well freehand.