hi,
I was wandering about the timestamp support in SQlite. I've tried this:
sqlite> create table test(time TIMESTAMP); sqlite> insert into test (time) values ('2004-1-12 12:23:32'); sqlite> select extract( month from time) from test;
SELECT strftime("%m",time) FROM test;
See http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
SQL error: near "from": syntax error
But I'm afraid my knowledge of SQL is too tiny to guess if it's a syntax mistake or simply SQlite that does not support the TIMESTAMP value.
Thanks a lot.
Guille
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
