Re: [sqlite] time is off

2006-09-18 Thread drh
TiNo <[EMAIL PROTECTED]> wrote: > example: > > sqlite> select datetime('now'); > 2006-09-18 10:11:48 > sqlite> select datetime('now','utc'); > 2006-09-18 08:11:52 > sqlite> select datetime('now','localtime'); > 2006-09-18 12:11:58 > > > select datetime('now') shows utc time, Localtime shows my

Re: [sqlite] time is off

2006-09-18 Thread Jay Sprenkle
On 9/18/06, TiNo <[EMAIL PROTECTED]> wrote: example: sqlite> select datetime('now'); 2006-09-18 10:11:48 sqlite> select datetime('now','utc'); 2006-09-18 08:11:52 sqlite> select datetime('now','localtime'); 2006-09-18 12:11:58 select datetime('now') shows utc time, Localtime shows my

[sqlite] time is off

2006-09-18 Thread TiNo
example: sqlite> select datetime('now'); 2006-09-18 10:11:48 sqlite> select datetime('now','utc'); 2006-09-18 08:11:52 sqlite> select datetime('now','localtime'); 2006-09-18 12:11:58 select datetime('now') shows utc time, Localtime shows my localtime, but now,utc is off. It should be the same