select * from table where to_char(date,'yyyymmdd')='20100108';