On 7/29/2014 8:23 PM, Will Fong wrote:
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.
Well, SQLite delegates to the C runtime for timezone handling. I suspect tzset() et al could be used to trick it into assuming a timezone of your choice. That's per process though, not per connection.
Alternatively, there is 'N hours' modifier for date/time functions (N may be negative). That's much more manual though, as the modifiers will have to be written into every query, possibly as bound parameters.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
