When you rotate two polarizers with respect to each other the field darkens. As the field becomes very dark it may acquire a blue or red tint depending on material details.
Do not let this tinting worry you; there are many stops of darkening available before tinting becomes a problem.
A circular polarizer should be stacked first to a DSLR's lens; the polarizer stacked atop it should be a linear or a
reversed* circular polarizer.
If both polarizers in a stack are circular, there will be minimal effect on decreasing the relative brightness of reflections, sky, etc..
Dave in Iowa
* use a reversing ring or remove the polarizer's glass element, reverse it, and replace it.