2 echo create table t1
(f1 int
,f2
date);
4 echo insert into t1 values
(1,'2008-10-29');
5 Statement Executed
: Rows Affected
= 1
6 echo insert into t1 values
(2,'28-12-2008');
7 Statement prepare failed with error
-16
8 echo insert into t1 values
(3,'2008-2-30');
9 Statement prepare failed with error
-16
10 echo insert into t1 values
(4,'2008-3- -20');
11 Statement prepare failed with error
-16
12 echo insert into t1 values
(5,NULL
);
13 Statement Executed
: Rows Affected
= 1
14 echo insert into t1 values
(6,'2007-05-05');
15 Statement Executed
: Rows Affected
= 1
16 echo select * from t1
;
17 ---------------------------------------------------------
19 ---------------------------------------------------------
24 echo select * from t1 where f2
<='2007-05-05';
25 ---------------------------------------------------------
27 ---------------------------------------------------------
30 echo select * from t1 where f2
>='2007-05-05';
31 ---------------------------------------------------------
33 ---------------------------------------------------------
37 echo select * from t1 where f2
='2007-05-05';
38 ---------------------------------------------------------
40 ---------------------------------------------------------