1 echo create table t1 (f1 int,f2 date);
2 create table t1 (f1 int,f2 date);
3 echo insert into t1 values(1,'2008-10-29');
4 insert into t1 values(1,'2008-10-29');
5 echo insert into t1 values(2,'28-12-2008');
6 insert into t1 values(2,'28-12-2008');
7 echo insert into t1 values(3,'2008-2-30');
8 insert into t1 values(3,'2008-2-30');
9 echo insert into t1 values(4,'2008-3- -20');
10 insert into t1 values(4,'2008-3- -20');
11 echo insert into t1 values(5,NULL);
12 insert into t1 values(5,NULL);
13 echo insert into t1 values(6,'2007-05-05');
14 insert into t1 values(6,'2007-05-05');
15 echo select * from t1;
17 echo select * from t1 where f2<='2007-05-05';
18 select * from t1 where f2<='2007-05-05';
19 echo select * from t1 where f2>='2007-05-05';
20 select * from t1 where f2>='2007-05-05';
21 echo select * from t1 where f2='2007-05-05';
22 select * from t1 where f2='2007-05-05';