[sqlite] Не осилил даты

~$ sqlite
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> create table test(time int);
sqlite> insert into test values (date('now'));
sqlite> insert into test values (date('now'));
sqlite> select * from test;
2009-04-14
2009-04-14
sqlite> insert into test values (datetime('now'));
sqlite> insert into test values (datetime('now'));
sqlite> insert into test values (datetime('now'));
sqlite> insert into test values (datetime('now'));
sqlite> SELECT datetime('now');
2009-04-14 18:55:06
sqlite> select * from test where time>datetime('now');
sqlite> select * from test where time<datetime('now');
2009-04-14
2009-04-14
2009-04-14 18:55:03
2009-04-14 18:55:03
2009-04-14 18:55:04
2009-04-14 18:55:04
sqlite> 

Спасибо, теперь врубился :)