Some moments of my childhood have a melancholic impact on me.

Does the sentence below sound natural in English?

Some moments of my childhood have a melancholic impact on me.

That sounds as though they still affect you. If this is your meaning, then it is fine. Otherwise it should be "had" or "have had".

OK, I meant it (that they still affect me). Thank you! :)