That returned the expected results. So in other words, even though 'UTC' is a valid option, it shouldn't be used?
On Tue, Dec 20, 2011 at 8:41 AM, Kit <[email protected]> wrote: > 2011/12/20 Stephen Chrzanowski <[email protected]>: > > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
