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 <kit.sa...@gmail.com> wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
