1 echo Create table t1
(f1 timestamp
, f2 timestamp
);
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 ---------------------------------------------------------
12 2001/1/1 1:1:1.0 2001/1/20 1:1:1.0
13 2002/1/1 1:1:1.0 2002/2/20 1:1:1.0
14 2003/1/1 1:1:1.0 2003/2/20 1:1:1.0
15 2004/1/1 1:1:1.0 2004/2/20 1:1:1.0
16 2005/1/1 1:1:1.0 2005/11/20 1:1:1.0
18 echo select * from t1 where timestamp_add
(f2 interval
15 day
) ='2001-02-04 01:01:01';
19 ---------------------------------------------------------
21 ---------------------------------------------------------
22 2001/1/1 1:1:1.0 2001/1/20 1:1:1.0
24 echo select * from t1 where timestamp_add
(f2 interval
15 day
)<='2002-03-07 01:01:01';
25 ---------------------------------------------------------
27 ---------------------------------------------------------
28 2001/1/1 1:1:1.0 2001/1/20 1:1:1.0
29 2002/1/1 1:1:1.0 2002/2/20 1:1:1.0
31 echo select * from t1 where timestamp_add
(f2 interval
15 day
)>='2003-03-07 01:01:01';
32 ---------------------------------------------------------
34 ---------------------------------------------------------
35 2003/1/1 1:1:1.0 2003/2/20 1:1:1.0
36 2004/1/1 1:1:1.0 2004/2/20 1:1:1.0
37 2005/1/1 1:1:1.0 2005/11/20 1:1:1.0
39 echo select * from t1 where timestamp_add
(f2 interval
15 day
) ='2004-03-06 01:01:01';
40 ---------------------------------------------------------
42 ---------------------------------------------------------
43 2004/1/1 1:1:1.0 2004/2/20 1:1:1.0
45 echo select * from t1 where timestamp_add
(f2 interval
15 day
)!='2005-12-05 01:01:01';
46 ---------------------------------------------------------
48 ---------------------------------------------------------
49 2001/1/1 1:1:1.0 2001/1/20 1:1:1.0
50 2002/1/1 1:1:1.0 2002/2/20 1:1:1.0
51 2003/1/1 1:1:1.0 2003/2/20 1:1:1.0
52 2004/1/1 1:1:1.0 2004/2/20 1:1:1.0
54 echo select * from t1 where timestamp_add
(f2 interval
45 day
) ='2006-01-04 01:01:01';
55 ---------------------------------------------------------
57 ---------------------------------------------------------
58 2005/1/1 1:1:1.0 2005/11/20 1:1:1.0
60 echo select * from t1 where timestamp_add
(f2 interval
45 day
)!='2006-01-04 01:01:01';
61 ---------------------------------------------------------
63 ---------------------------------------------------------
64 2001/1/1 1:1:1.0 2001/1/20 1:1:1.0
65 2002/1/1 1:1:1.0 2002/2/20 1:1:1.0
66 2003/1/1 1:1:1.0 2003/2/20 1:1:1.0
67 2004/1/1 1:1:1.0 2004/2/20 1:1:1.0