On 30 Jul 2014, at 6:05pm, Nico Williams <n...@cryptonector.com> wrote:
> Ideally we'd all just use Zulu time all the time, but that won't fly. If this is web-facing, the problem is solved. JavaScript can be told to return 'now' expressed in UTC. "The Date.now() method returns the number of milliseconds elapsed since 1 January 1970 00:00:00 UTC." If you assume that every user has the timezone set correctly on their computer, you just need to trust what JavaScript returns. A timezone selected by the user is used only when displaying dates, or in setting dates in the future. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users