test/tools/csql/exp.testnw009.ksh

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