Hi, On Wed, Jul 30, 2014 at 8:38 AM, Simon Slavin <slav...@bigfraud.org> wrote: > 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
I can store each user's timezone setting as "[+-]HH:MM". But I can only apply that to GMT values. So when I'm reading from the database, it's a trivial operation. However, if a user specifies a datetime, I would have to provide the reverse of that value to convert the user time into GMT. It would be a bit easier (yet still messy) if the timezone was just an integer, then I could just "*-1". But the ":MM" seems to make it a messy string operation. Is this the only option? It seems like there would have been a "better" way to handle this. Thanks, -will _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
