No, it's just a legend. A simple well is not enough to turn a bright sunny sky into visible to the stars. This is due to the Earth's atmosphere, which scatters sunlight everywhere. The amount of this scattered light during the day will far exceed the brightness of any other star.