New bladder cancer diagnosis…need help!

I am a 57 yo male. Retired from the NYC fire dept and now live in upstate NY. On Feb 9th 09 I had a PET scan and saw  my urologist. I was scoped and he said that I had a tumor. I now have an appointment on March 3rd for surgery. I do not know what to expect.  I am really lost. Can anyone answer a few questions.

Should I go for a second opinion?

How long will it take for me to be back to "normal"?

Does the scoping effect sexual function?