My boss is forcing me to have both UTC and local time in the database. I've pointed out this is a colossal waste of time and space and then said, "Yes, sir.":) -----Original Message----- From: tz-bounces@iana.org [mailto:tz-bounces@iana.org] On Behalf Of Jaakko Hyvätti Sent: Thursday, December 08, 2011 7:21 AM To: tz@iana.org Subject: Re: [tz] User time zones What others have said, I would put simply: always transmit and store times in UTC. Only convert to local timezones in user interfaces. Otherwise, you'll lose your mind, fast. Also, force your data sources to use UTC. Otherwise, they'll lose their mind too. -- Foreca Ltd Jaakko.Hyvatti@foreca.com Tammasaarenkatu 5, FI-00180 Helsinki, Finland http://www.foreca.com