Create date Null
select * from table1 where create date < TRUNC(SYDATE) Requirement : I have check create date should be less than sysdate. if column is NULL, how to perform