This was asked in another thread in this forum. Because I put a lot of effort into the answer, I thought I would re-post this as its own thread so others can benefit from my answer as well:
<PROFESSOR MODE ON>
Color Temperature is the measurement of color expressed in Kelvin (K). The reason this measurement is called a "temperature" is because it was derived from a theoretical object called a "black body radiator." When the radiator is heated, it changes from black to red to yellow to white to blue. The lower the Kelvin rating, the "warmer" or more yellow the light. The higher the rating, the "cooler" or more blue the light. It does not actually reflect the actual heat temperature of a light. For example, you can have an 18,000K fluorescent lamp which is cool to the touch. Therefore if you are using a light source such as fluorescent lighting, you will probably not affect the physical heat temperature of the water. Now if you use Metal Halide as a light source, you will need to have a decent distance between the tank and the lamp if you do not wish to heat up the tank.
Here is the color temperature spectrum in Kelvin (K):
Freshwater aquatic plants require peaks in the red spectrum for optimal growth, as freshwater aquatic plants' photosynthetic ability is most sensitive to red light.
Coral requires mostly intense blue light, hence the need for actinic lights. Blue light which is produced is generally not used by freshwater plants and therefore should be avoided.
If one were to use a light source which produced peaks in the red and blue spectrums, the overall effect would look quite garish. If one were to use only red light, the fish in the tank would look rather odd. Now we all want our fish and plants to look their best, so to compromise, there are full spectrum lights in several temperature ranges, and depending on the look you would like to go for.
Referencing the color temperature chart above, typical bright sunny days average between 6000K and 7000K. We all agree that clean bright sun is what makes our fish look the nicest, and as a side effect, generally helps us grow healthy plants.
Therefore, as a result the optimum spectrum for an aquarium would be 6,700K as it offers the most realistic lighting for fish, and the necessary red wavelengths for plants to photosynthesize properly. So that color temp is a win win situation.
10,000K light would emulate the light from an overcast day in real life, 18,000K would be closing in on Actinic light, which would not be beneficial to freshwater aquatic plants, so I would avoid such color temperatures in a freshwater tank.
<PROFESSOR MODE OFF>
I hope this information helps you....