The best time for the photographer are the evening hours, the blue hour or the night. In the evening hours there are long shadows, soft, warm light, which then gradually passes into the blue hour.
During the day everyone can photograph, the blue hour and the night usually requires a tripod. In the available light photography, a tripod is also useful, but with low light lenses with image stabilizers and correspondingly higher ISO one can also shoot from the hand.
Day to Night, Time Lapse, TimeORama: