YAN HONG YE wrote:
> the current time is 15:15
> when I use this following command:
> sqlite> Select time('now');
> return 07:15:42
> not current time,why?
Make it
select time('now', 'localtime'
YAN HONG YE writes:
> the current time is 15:15
> when I use this following command:
> sqlite> Select time('now');
> return 07:15:42
> not current time,why?
Read http://www.sqlite.org/lang_datefunc.html
"Format 11, the string 'now', is converted into
the current time is 15:15
when I use this following command:
sqlite> Select time('now');
return 07:15:42
not current time,why?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3 matches
Mail list logo