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_diff
(f2
,f1
)=2;
19 ---------------------------------------------------------
21 ---------------------------------------------------------
24 echo select * from t1 where time_diff
(f1
,f2
)=2;
25 ---------------------------------------------------------
27 ---------------------------------------------------------
29 echo select * from t1 where time_diff
(f2
,f1
)=60;
30 ---------------------------------------------------------
32 ---------------------------------------------------------
35 echo select * from t1 where time_diff
(f2
,f1
)=120;
36 ---------------------------------------------------------
38 ---------------------------------------------------------
41 echo select * from t1 where time_diff
(f2
,f1
)=3600;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
47 echo select * from t1 where time_diff
(f2
,f1
)=3661;
48 ---------------------------------------------------------
50 ---------------------------------------------------------
53 echo select * from t1 where time_diff
(f2
,f1
)<120;
54 ---------------------------------------------------------
56 ---------------------------------------------------------
60 echo select * from t1 where time_diff
(f2
,f1
)<=120;
61 ---------------------------------------------------------
63 ---------------------------------------------------------
68 echo select * from t1 where time_diff
(f2
,f1
)>120;
69 ---------------------------------------------------------
71 ---------------------------------------------------------
75 echo select * from t1 where time_diff
(f2
,f1
)>=120;
76 ---------------------------------------------------------
78 ---------------------------------------------------------
83 echo select * from t1 where time_diff
(f2
,f1
)!=120;
84 ---------------------------------------------------------
86 ---------------------------------------------------------
92 echo select * from t1 where time_diff
(f2
,'01:01:01')=2;
93 ---------------------------------------------------------
95 ---------------------------------------------------------
98 echo select * from t1 where time_diff
(f2
,'01:01:01')>=120;
99 ---------------------------------------------------------
101 ---------------------------------------------------------
106 echo select * from t1 where time_diff
(f2
,'01:01:01')!=3600;
107 ---------------------------------------------------------
109 ---------------------------------------------------------
115 echo select * from t1 where time_diff
('01:01:02','01:01:01')=1;
116 ---------------------------------------------------------
118 ---------------------------------------------------------