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.
Upon the death of a star (in a nova or a supernova) these high mass elements, along with even more massive nuclei created during the nova or supernova, were thrown out into space to eventually become incorporated into another star or celestial body.