Hi there
I can not fix this error for about 2 hours.
What am I doing wrong?
when I query like below, I get 'Data type mismatch in criteria expression' or 'invalid use of null'. The message changes when I change where clause.
mycolumn is varchar type and has null values. and data format is like yyyy-MM-dd HH:mm:ss
I can not find anything wrong
I can not fix this error for about 2 hours.
What am I doing wrong?
when I query like below, I get 'Data type mismatch in criteria expression' or 'invalid use of null'. The message changes when I change where clause.
orselect * from my_table where cdate('2022-05-24 23:07:07') < cdate(nz(mycolumn,'2000-01-01 00:00:00'));
select * from my_table where mycolumn is not null and cdate('2022-05-24 23:07:07') < cdate(mycolumn);
mycolumn is varchar type and has null values. and data format is like yyyy-MM-dd HH:mm:ss
I can not find anything wrong