Try select time('now', 'localtime');
Michael
-----Ursprüngliche Nachricht-----
Von: Stephen Leaf [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 1. Juli 2005 15:47
An: sqlite-users@sqlite.org
Betreff: [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
