1 echo Create table t1
(f1
date, f2
time);
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
(minute from f2
) = 30;
19 ---------------------------------------------------------
21 ---------------------------------------------------------
24 echo select * from t1 where extract
(minute from f2
) < 30;
25 ---------------------------------------------------------
27 ---------------------------------------------------------
31 echo select * from t1 where extract
(minute from f2
)<= 30;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
39 echo select * from t1 where extract
(minute from f2
) > 30;
40 ---------------------------------------------------------
42 ---------------------------------------------------------
46 echo select * from t1 where extract
(minute from f2
)>= 30;
47 ---------------------------------------------------------
49 ---------------------------------------------------------
54 echo select * from t1 where extract
(minute from f2
)!= 30;
55 ---------------------------------------------------------
57 ---------------------------------------------------------