Re: [sqlite] Select time('now')

2012-04-13 Thread Igor Tandetnik
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'

Re: [sqlite] Select time('now')

2012-04-13 Thread Steinar Midtskogen
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

[sqlite] Select time('now')

2012-04-13 Thread YAN HONG YE
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