On Thu, 2005-07-21 at 22:32 +0200, Cyril Scetbon wrote: > Hi, > > I don't understand why when I use select CURRENT_TIME from sqlite I get > a false value as follows : > > [EMAIL PROTECTED]:~$ date > Thu Jul 21 22:37:20 CEST 2005 > [EMAIL PROTECTED]:~$ sqlite3 /tmp/test.db "select CURRENT_TIME" > 20:37:26 >
CURRENT_TIME returns the time in UTC which is 2 hours to the west of CEST, apparently. -- D. Richard Hipp <[EMAIL PROTECTED]>
