It's a follow-up to the previous post.
As it turned out, implicit date conversions may also prevent Oracle from
doing the partition
For example, if you have a table
INVOICES with a range partition on
INVOICE_DATE field, then expression
SELECT ... WHERE invoice_date >= '01-MAR-09' AND invoice_date < '02-MAR-09'
will not perform …more ...