On 30/07/14 10:05, Nico Williams wrote: > Users travel; they don't have a single timezone. What matters is: the > TZ when a user posted / did something, so you can have a vague idea of > when they might be sleeping / unavailable.
I'm not sure if you are disagreeing or agreeing with me. A clearer way of saying it is that I believe timezones are a formatting issue, and best dealt as close to the user as possible. For this specific discussion the user is in front of a browser, so I believe the browser is the best place to care about the timezones. Browsers pick up timezone and formatting preferences from the operating system they run on which in turn is based on user preferences. There is no need for timezones even for your example. Displaying the timestamp relatively solves that (eg "13 hours ago"). Roger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
