C-section

So I'm having a c-section on the 20th😱 and I'm so scared. This is my first baby. I'm mostly afraid of the spinal or epidural which ever they decide to use. Does it really hurt like I've been told? People tell me that it will hurt me because I will not have contractions to distract me from the pain of the needle.