test/sql/ScalarFunction/exp.test037.ksh

   1 echo Create table t1(f1 date, f2 time);
   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/1/1        23:59:59.0
  13         2002/1/1        22:58:58.0
  14         2003/1/3        12:30:30.0
  15         2004/1/1        2:2:2.0
  16         2005/1/1        1:1:1.0
  17
  18 echo select * from t1 where extract(minute from f2) = 30;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2
  21 ---------------------------------------------------------
  22         2003/1/3        12:30:30.0
  23
  24 echo select * from t1 where extract(minute from f2) < 30;
  25 ---------------------------------------------------------
  26         t1.f1   t1.f2
  27 ---------------------------------------------------------
  28         2004/1/1        2:2:2.0
  29         2005/1/1        1:1:1.0
  30
  31 echo select * from t1 where extract(minute from f2)<= 30;
  32 ---------------------------------------------------------
  33         t1.f1   t1.f2
  34 ---------------------------------------------------------
  35         2003/1/3        12:30:30.0
  36         2004/1/1        2:2:2.0
  37         2005/1/1        1:1:1.0
  38
  39 echo select * from t1 where extract(minute from f2) > 30;
  40 ---------------------------------------------------------
  41         t1.f1   t1.f2
  42 ---------------------------------------------------------
  43         2001/1/1        23:59:59.0
  44         2002/1/1        22:58:58.0
  45
  46 echo select * from t1 where extract(minute from f2)>= 30;
  47 ---------------------------------------------------------
  48         t1.f1   t1.f2
  49 ---------------------------------------------------------
  50         2001/1/1        23:59:59.0
  51         2002/1/1        22:58:58.0
  52         2003/1/3        12:30:30.0
  53
  54 echo select * from t1 where extract(minute from f2)!= 30;
  55 ---------------------------------------------------------
  56         t1.f1   t1.f2
  57 ---------------------------------------------------------
  58         2001/1/1        23:59:59.0
  59         2002/1/1        22:58:58.0
  60         2004/1/1        2:2:2.0
  61         2005/1/1        1:1:1.0
  62
  63 Statement Executed