On Friday 01 July 2005 08:58 am, [EMAIL PROTECTED] wrote: > Try select time('now', 'localtime'); > Michael that did it! come to think of it .. I don't remember date saying CDT before.
Where can I find all of these functions documented? I searched the sqlite docs but didn't find anything. unless I didn't look in the right place? I'd assume this is just all standard SQL however where is a good place to read up on that? in the past I just read the DBMS site. > > -----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