Oracle: filter date type column in where sql clause

Use to_date() method:


where (DPFOLIO.BUDGET_PROD.MONTH > to_date('12/31/2005 12:00:00 AM','MM/DD/YYYY HH12:MI:SS AM'))

Reference:

http://en.allexperts.com/q/Oracle-1451/oracle-date-filtering-cause.htm