TO_CHAR(date column to format , ‘DD-Mon-YYYY’) = ’10-May-2008′

THis function comes handy to do quick date comparisions.