Signifigant other not wanting sex when finding out your pregnant.

Emily
Has anyones signifigant other stopped wanting sex when they found out you were pregnant. He has said all week he is not in the mood and it really hurts my feelings. How long will it take for him to come out of this funk.