How long does it take for a brand new climbing shoes stretch out enough for you to feel comfortable in them?

It will take for about a week to two weeks. Use it as much as you can; walk around the house to break them in and make sure that your feet are used to the feel of your shoes before you actually use them to climb.