On 30 Jul 2014, at 1:23am, Will Fong <w...@digitaldev.com> wrote: > On Wed, Jul 30, 2014 at 8:16 AM, Igor Tandetnik <i...@tandetnik.org> wrote: >> 'localtime' and 'utc' modifiers. > > Ah! I have not explained my issue properly :) I'm very sorry about that. > > I'm using SQLite as a backend to a small website and I have users in > multiple timezones. When users login, their timezone is retrieved from > the user table.
Store their timezones in the format "[+-]HH:MM" and apply them by appending that text to any dates they provide. See the "Time Strings" section of <http://www.sqlite.org/lang_datefunc.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
