The King of the universe will raise us up to an everlasting renewal of life, because we have died for his laws. 538 One cannot but choose to die at the hands of men and to cherish the hope that God gives of being raised again by him. 539
Catechism number 1001
When? Definitively "at the last day," "at the end of the world."555 Indeed, the resurrection of the dead is closely associated with Christ's Parousia:
Risen with Christ