[sqlite] Timestamp support

[Guillermo Fernandez Castellanos]

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;
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]