2011/12/20 Stephen Chrzanowski <pontia...@gmail.com>: > I live in GMT-5 (America/Toronto). Current time is 8:06am, which should be > 13:06Z. However, according to this: > > select datetime('now','localtime'),datetime('now','utc'); > datetime('now','localtime') datetime('now','utc') > 2011-12-20 08:05:24 2011-12-20 18:05:24
Try select datetime('now'); -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users