The BBC has a rather sobering article about time zones here: http://www.bbc.co.uk/news/world-12849630. Fascinating stuff that explains how time zones work and how dates and times came to be so complicated.
Next time somebody gives you an earful about how your query gave them the wrong data because of some subtlety about the time portion of a datetime, a time zone difference, or daylight saving time, you could always point them to this. It might make you look less bad. (I’m just saying.)