Am 10.07.2014 um 23:26 schrieb Esteban A. Maringolo <emaring...@gmail.com>:
> What is the best way to work across timezones? > > Today my app assumes a global, shared, timezone for data input, storage, etc. > I want to make this configurable, and for that purpose I > > For what I read and thought about, I understand that the best way to > avoid any complication is to store and transfer (between > client/server) everything in UTC, and use timezone offset only to > convert to/from in order to display the Date and Time. > > Does anybody have a good article regarding working across timezones? > Any tip or suggestion for its use with PostgreSQL and GLORP? I think the only purpose is to have a reference point that is common. It doesn't matter if you transfer dates and times in UTC. That is what the offset is for. You can get the local time from a client but you store it in UTC (which will do the calculation of the offset). If you have a interface to a client you just deliver a correct offset but UTC is good thing here. The proper display of timezones is the duty of the client. If you produce web pages you need to get the timezone information from the user or in a web environment you do that locally with javascript. Hope that helps anyhow, Norbert
