Eugene,
> create table test(a int, b datetime);
> insert into test values(1,'2004/1/3');
> select * from test where date(b)='2004/1/3'
> The SELECT statement returns no record.
But this works:
sqlite> select * from test where b='2004/1/3';
1|2004/1/3
The date is not encoded properly in the database. Look again at the
date formats shown on the web page.
> Similarly, the statement:
> select date(b) from test
> does not return anything either.
> Perhaps I misunderstood the usage of those functions?
Here's an example...
sqlite> insert into test values (2,datetime("now","localtime"));
sqlite> select * from test where date(b) = "2004-01-03";
2|2004-01-03 22:28:56
sqlite>
e
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
