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

Reply via email to