2 Statement Executed
: Rows Affected
= 1
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
8 ---------------------------------------------------------
10 ---------------------------------------------------------
17 echo select * from t1 where extract
(year from
'2001-01-01') = 2001;
18 ---------------------------------------------------------
20 ---------------------------------------------------------
27 echo select * from t1 where extract
(year from f2
) = 2002;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
34 echo select * from t1 where extract
(year from f2
) < 2002;
35 ---------------------------------------------------------
37 ---------------------------------------------------------
41 echo select * from t1 where extract
(year from f2
)<= 2002;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
50 echo select * from t1 where extract
(year from f2
) > 2002;
51 ---------------------------------------------------------
53 ---------------------------------------------------------
56 echo select * from t1 where extract
(year from f2
)>= 2002;
57 ---------------------------------------------------------
59 ---------------------------------------------------------
64 echo select * from t1 where extract
(year from f2
)!= 2002;
65 ---------------------------------------------------------
67 ---------------------------------------------------------