See Ecclesiastes 8:12, note; Ecclesiastes 8:14, note. The living are conscious that there is a future before them: but the dead are unconscious; they earn nothing, receive nothing, even the memory of them soon disappears; they are no longer excited by the passions which belong to people in this life; their share in its activity has ceased. Solomon here describes what he sees, not what he believes; there is no reference here to the fact or the mode of the existence of the soul in another world, which are matters of faith.
The last clause of Ecclesiastes 9:6 indicates that the writer confines his observations on the dead to their portion in, or relation to, this world.
Now - Rather: “long ago.”