ORA-01830: date format picture ends before converting entire input string / Select sum where date query
I think you should not rely on the implicit conversion. It is a bad practice. Instead you should try like this: datenum >= to_date(’11/26/2013′,’mm/dd/yyyy’) or like datenum >= date ‘2013-09-01’