test/sql/ScalarFunction/extract_year_from_date.sql

   1 Create table t1(f1 date, f2 date);
   2 insert into t1 values('2001-01-01', '2001-01-01');
   3 insert into t1 values('2001-01-01', '2001-02-03');
   4 insert into t1 values('2001-01-03', '2002-03-03');
   5 insert into t1 values('2001-01-01', '2002-01-04');
   6 insert into t1 values('2001-01-01', '2003-04-05');
   7 echo select * from t1;
   8 select * from t1;
   9 echo select * from t1 where extract(year from '2001-01-01') = 2001;
  10 select * from t1 where extract(year from '2001-01-01') = 2001;
  11 echo select * from t1 where extract(year from f2) = 2002;
  12 select * from t1 where extract(year from f2) = 2002;
  13 echo select * from t1 where extract(year from f2) < 2002;
  14 select * from t1 where extract(year from f2) < 2002;
  15 echo select * from t1 where extract(year from f2)<= 2002;
  16 select * from t1 where extract(year from f2)<= 2002;
  17 echo select * from t1 where extract(year from f2) > 2002;
  18 select * from t1 where extract(year from f2) > 2002;
  19 echo select * from t1 where extract(year from f2)>= 2002;
  20 select * from t1 where extract(year from f2)>= 2002;
  21 echo select * from t1 where extract(year from f2)!= 2002;
  22 select * from t1 where extract(year from f2)!= 2002;