select ... from table where table.day_in_month = to_number(to_char(sysdate,'dd'))