1 echo Create table t1
(f1
date, f2
date);
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
9 ---------------------------------------------------------
11 ---------------------------------------------------------
18 echo select * from t1 where extract
(day from f2
) = 02;
19 ---------------------------------------------------------
21 ---------------------------------------------------------
25 echo select * from t1 where extract
(day from f2
) < 02;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
32 echo select * from t1 where extract
(day from f2
)<= 02;
33 ---------------------------------------------------------
35 ---------------------------------------------------------
41 echo select * from t1 where extract
(day from f2
) > 02;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
47 echo select * from t1 where extract
(day from f2
)>= 02;
48 ---------------------------------------------------------
50 ---------------------------------------------------------
55 echo select * from t1 where extract
(day from f2
)!= 02;
56 ---------------------------------------------------------
58 ---------------------------------------------------------