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
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
15 2002/1/1 1:1:1.0 2002/1/1 1:1:1.0
16 2002/1/1 1:1:1.0 2002/2/3 1:1:1.0
17 2002/1/1 1:1:1.0 2002/3/1 1:1:1.0
18 2002/1/1 1:1:1.0 2004/2/1 1:1:1.0
19 2002/1/1 1:1:1.0 2004/3/1 1:1:1.0
20 2001/1/1 1:1:1.0 2002/2/3 1:1:1.0
21 2001/1/1 1:1:1.0 2002/3/1 1:1:1.0
22 2001/1/1 1:1:1.0 2004/2/1 1:1:1.0
23 2001/1/1 1:1:1.0 2004/3/1 1:1:1.0
25 echo select * from t1 where timestamp_diff
(year
,f1
,f2
)=0;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
29 2002/1/1 1:1:1.0 2002/1/1 1:1:1.0
30 2002/1/1 1:1:1.0 2002/2/3 1:1:1.0
31 2002/1/1 1:1:1.0 2002/3/1 1:1:1.0
33 echo select * from t1 where timestamp_diff
(year
,f2
,f1
)=2;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
37 2002/1/1 1:1:1.0 2004/2/1 1:1:1.0
38 2002/1/1 1:1:1.0 2004/3/1 1:1:1.0
40 echo select * from t1 where timestamp_diff
(year
,f2
,f1
)>2;
41 ---------------------------------------------------------
43 ---------------------------------------------------------
44 2001/1/1 1:1:1.0 2004/2/1 1:1:1.0
45 2001/1/1 1:1:1.0 2004/3/1 1:1:1.0
47 echo select * from t1 where timestamp_diff
(year
,f2
,f1
)<=2;
48 ---------------------------------------------------------
50 ---------------------------------------------------------
51 2002/1/1 1:1:1.0 2002/1/1 1:1:1.0
52 2002/1/1 1:1:1.0 2002/2/3 1:1:1.0
53 2002/1/1 1:1:1.0 2002/3/1 1:1:1.0
54 2002/1/1 1:1:1.0 2004/2/1 1:1:1.0
55 2002/1/1 1:1:1.0 2004/3/1 1:1:1.0
56 2001/1/1 1:1:1.0 2002/2/3 1:1:1.0
57 2001/1/1 1:1:1.0 2002/3/1 1:1:1.0