Why didn't I think to it ?
thanks sqlite-users :-)
Selon Joseph Bruni <[EMAIL PROTECTED]>:
> 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,
> >
> > 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
> >
> >
> > thanks
> >
>
>
