Rods are very sensitive to light and are responsible for our night vision only, as they become bleached (overloaded) at very low levels of light (8 cd/m² is about the point of too bright for the rods). Rods are monochromatic, and have a peak sensitivity at a wavelength that we were generally consider teal, however we don't really have color perception in our night vision.
Cones come in three varieties, and are responsible for our daytime color vision. The three varieties are called L M S for long wave medium wave and short wavelength, relating to the wavelengths of light they most respond to.
The L cone extends all the way down to what we would call deep red but has peak sensitivity in yellow, the M Cone does not extend down as far and peaks in a deeper green. The S Cone peaks in a deep blue violet.
Only the L and M cones exist in the central foveal vision. Rods and S cones exist in the peripheral vision, and L&M cones exist there as well, but in less dense numbers than in the central foveal vision. The highest resolution area of our vision is the central foveal area, a very narrow area—if you outstretched your arm and then look at your thumb, your thumbnail is a bit larger than your central foveal area in terms of the visual angle.
The blind spot caused by the optic nerve is a distance away from the foveal central vision, and it has neither cones nor rods.
L and M cones combine to make the luminance channel which is the achromatic lightness/darkness which in the human vision system contains all of the spatial detail. And while we have many more rods than cones, the rods are grouped together in such a way that our night vision is at a much lower resolution than our daytime vision.
The reason red is sometimes used in places such as dark cockpits at night, is that it stimulates the L cone while avoiding any stimulation of the rods, so that it doesn't affect the dark adaptation/night vision.
--------
Thus, because there are no rods in the central foveal pit, we have no night vision in our central vision, which is why when we are using only our rods we are also using only our peripheral vision. This has nothing to do with the blindspot that is caused by the optic nerve which is a completely separate physiological issue.