Hi, I am not sure but one is in GMT and other maybe in your local time zone.
Regards Sudhir -----Original Message----- From: Stephen Leaf [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 9:47 AM To: sqlite-users@sqlite.org Subject: [sqlite] time zone? sqlite> select time('now'); 13:45:20 $ date Fri Jul 1 08:45:37 CDT 2005 anyone know what's wrong? thanks, Stephen