test/tools/csql/exp.test012.ksh

   1 echo create table t1 (f1 int,f2 date);
   2 Statement Executed
   3 echo insert into t1 values(1,'2008-10-29');
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(2,'28-12-2008');
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(3,'2008-2-30');
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(4,'2008-3- -20');
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1 values(5,NULL);
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t1 values(6,'2007-05-05');
  14 Statement Executed: Rows Affected = 1
  15 echo select * from t1;
  16 ---------------------------------------------------------
  17         t1.f1   t1.f2
  18 ---------------------------------------------------------
  19         1       2008/10/29
  20         2       0/0/0
  21         3       0/0/0
  22         4       0/0/0
  23         5       NULL
  24         6       2007/5/5
  25
  26 echo select * from t1 where f2<='2007-05-05';
  27 ---------------------------------------------------------
  28         t1.f1   t1.f2
  29 ---------------------------------------------------------
  30         2       0/0/0
  31         3       0/0/0
  32         4       0/0/0
  33         6       2007/5/5
  34
  35 echo select * from t1 where f2>='2007-05-05';
  36 ---------------------------------------------------------
  37         t1.f1   t1.f2
  38 ---------------------------------------------------------
  39         1       2008/10/29
  40         6       2007/5/5
  41
  42 echo select * from t1 where f2='2007-05-05';
  43 ---------------------------------------------------------
  44         t1.f1   t1.f2
  45 ---------------------------------------------------------
  46         6       2007/5/5
  47
  48 echo drop table t1;
  49 Statement Executed