1 echo Create table t1
(f1
time, 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 time_sub
(f2 interval
3000 second
) = '01:00:01';
19 ---------------------------------------------------------
21 ---------------------------------------------------------
24 echo select * from t1 where time_sub
(f2 interval
3000 second
) <= '01:00:01';
25 ---------------------------------------------------------
27 ---------------------------------------------------------
32 echo select * from t1 where time_sub
(f2 interval
3000 second
) >= '01:00:01';
33 ---------------------------------------------------------
35 ---------------------------------------------------------
40 echo select * from t1 where time_sub
(f2 interval
10200 second
) = '23:00:01';
41 ---------------------------------------------------------
43 ---------------------------------------------------------
46 echo select * from t1 where time_sub
(f2 interval
10200 second
)!= '23:00:01';
47 ---------------------------------------------------------
49 ---------------------------------------------------------
55 echo select * from t1 where time_sub
(f2 interval
10200 second
)<= '23:00:01';
56 ---------------------------------------------------------
58 ---------------------------------------------------------
63 echo select * from t1 where time_sub
(f2 interval
10200 second
) > '23:00:01';
64 ---------------------------------------------------------
66 ---------------------------------------------------------