where trunc(effdt) = trunc(sysdate) that will only give you the day, month and year - no time component