text: --pass unmatched types or formats of values
  
  set timezone '+9:00';
  
  drop table if exists coo;
  create class coo(
          col1 char(20),
          col2 nchar(20),
          col3 nchar varying(20),
          col4 bit(8),
          col5 bit varying(8),
          col6 numeric,
          col7 integer,
          col8 smallint,
          col9 monetary,
          col10 float,
          col11 double,
          col12 date,
          col14 timestampltz,
          col15 set,
          col16 multiset,
          col17 sequence,
          col18 blob,
          col19 clob,
  		col20 datetimeltz,
  		col21 varchar
  );
  
  insert into coo (col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12, col14,col15, col16, col17, col18, col19, col20, col21)
   values('aaa', n'aaa', n'aaa', b'0011', b'0011', 10, 11, 12, 13, 14, 15, '1/1/2008', '01/31/1994 8:15:00 pm', {10, 20}, {'abc','def'}, {50,60,70}, bit_to_blob(B'000010'), char_to_clob('character'), '2010-10-01 1:10:11.5678', 'aaa');
  
  insert into coo (col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12, col14,col15, col16, col17, col18, col19, col20, col21)
   values('bbb', n'bbb', n'bbb', b'1011', b'1010', 20, 21, 22, 23, 24, 25, '5/7/2010', '05/20/1985 8:15:00 pm', {11, 22}, {'ghj','yut'}, {80,90,100}, bit_to_blob(B'11100010'), char_to_clob('string'), '2022-11-12 12:12:12.1234', 'aaa');
  
  show columns in coo;
  
  --error, unmatched format
  select date(col1) from coo order by 1;
  --error, unmatched format
  select date(col2) from coo order by 1;
  --error, unmatched format
  select date(col3) from coo order by 1;
  --error, unmatched format
  select date(col21) from coo order by 1;
  --error, unmatched type
  select date(col4) from coo order by 1;
  --error, unmatched type
  select date(col5) from coo order by 1;
  --error, unmatched type
  select date(col6) from coo order by 1;
  --error, unmatched type
  select date(col7) from coo order by 1;
  --error, unmatched type
  select date(col8) from coo order by 1;
  --error, unmatched type
  select date(col9) from coo order by 1;
  --error, unmatched type
  select date(col10) from coo order by 1;
  --error, unmatched type
  select date(col11) from coo order by 1;
  --error, unmatched type
  select date(col12) from coo order by 1;
  --normal, timestamp argument
  select date(col14) from coo order by 1;
  --error, unmatched type
  select date(col15) from coo order by 1;
  --error, unmatched type
  select date(col16) from coo order by 1;
  --error, unmatched type
  select date(col17) from coo order by 1;
  --error, unmatched type
  select date(col18) from coo order by 1;
  --error, unmatched type
  select date(col19) from coo order by 1;
  --normal, datetime type argument
  select date(col20) from coo order by 1;
  
  
  delete from coo;
  drop table coo;
  
  set timezone 'Asia/Seoul';
  