The vast majority of people who visit the Eiffel Tower do so in the middle of the day. This is when all the tour groups visit and when the public transportation is running. However I highly recommending making a visit at night. It is a totally different experience and a completely different vibe than what you will experience during the day. Quite frankly it is a lot more fun.