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
because it is returning UTC (Coordinated Universal Time). Use 'localtime' to change it to localtime.
>sqlite3 foo.db "SELECT datetime('now','localtime')"
