> According to http://www.sqlite.org/lang_datefunc.html datetime('now') > returns date and time already as UTC. If you add 'utc' modifier then > it makes datetime() think that it's your local time and convert it to > 'utc' thus adding 4 hours (apparently you're in GMT -4 timezone).
Thanks. I figured out this nuance late last night. (Actually I'm in GMT -5, but with daylight savings.) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
