test/sql/ScalarFunction/exp.test004.ksh

   1 echo Create table t1(f1 date, f2 date);
   2 Statement Executed
   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 echo select * from t1;
   9 ---------------------------------------------------------
  10         t1.f1   t1.f2
  11 ---------------------------------------------------------
  12         2001/5/1        2001/5/1
  13         2001/6/1        2001/6/1
  14         2001/7/1        2002/7/1
  15         2001/8/1        2002/8/1
  16         2001/9/1        2002/9/1
  17
  18 echo select * from t1 where date_add(f1 interval 5 month) < '2001-12-01';
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2
  21 ---------------------------------------------------------
  22         2001/5/1        2001/5/1
  23         2001/6/1        2001/6/1
  24
  25 echo select * from t1 where date_add(f1 interval 6 month) = '2002-01-01';
  26 ---------------------------------------------------------
  27         t1.f1   t1.f2
  28 ---------------------------------------------------------
  29         2001/7/1        2002/7/1
  30
  31 echo select * from t1 where date_add(f1 interval 18 month)>= '2003-01-01';
  32 ---------------------------------------------------------
  33         t1.f1   t1.f2
  34 ---------------------------------------------------------
  35         2001/7/1        2002/7/1
  36         2001/8/1        2002/8/1
  37         2001/9/1        2002/9/1
  38
  39 Statement Executed