I am using the builtin DATEPART function to retrieve month, day and year from a date so I can pass it to the DATENAME function: Now that I have Month, Day, Year values individually, I pass it to my DATENAME to get the Weekname of the date I want: This returns an incorrect Day Name.
Leaving Main Life Sequence. When a massive star has expended all of its core hydrogen, this means that the gravitational forces pushing inward will overcome the fusion forces which had been pushing outward. The outer layers of the star will then compact inwards.
The core temperature of main sequence stars is hot enough (> about 10 million K) that hydrogen nuclei (protons) can overcome coulombic repulsion and fuse together. The net result of this is that through several steps, hydrogen is fused to form helium nuclei.