Re: [sqlite] CURRENT_TIME returns false value

[Joseph Bruni]

whalesong:~ brunij$ date
Thu Jul 21 13:40:42 MST 2005
whalesong:~ brunij$ sqlite3 /dev/null 'select current_time'
20:40:44


It works for me. I'm located at GMT-7. Where are you?

Perhaps what you wanted was:

select datetime('now','localtime');





On Jul 21, 2005, at 1:32 PM, Cyril Scetbon wrote:

Hi,



[EMAIL PROTECTED]:~$ date
Thu Jul 21 22:37:20 CEST 2005
[EMAIL PROTECTED]:~$ sqlite3 /tmp/test.db "select CURRENT_TIME"
20:37:26


thanks

I don't understand why when I use select CURRENT_TIME from sqlite I get a false value as follows :

smime.p7s
Description: S/MIME cryptographic signature